I have a table where there could be multiple rows for each lender which I would like to combine in a query.  For example:
Lender      Property Type
Lender A    Apartment
Lender A    Office

  I'm having what seems like a common problem where ' (apostrephes)
with a record are causing trouble when run through a query. I've read
about double quote putting the data theough if..then statements etc,
but have not been able to get anything to work. I'm making a list of

I have 2 dates I want to know how many days weeks and months went by (for
rental purpose)
I did Days: [Date in]-[Date Out] and this gives me a flat number of days (26
days, 13 days, 93 days)

Please explain why there isn't an Append Update Query function. How can I
create a query to append and update data?

I have a questionnaire database that contains participant’s demographic
information such as age, salary range, employee type, age group, departments,
location, and managers.  We want to be able to run reports that can show
participant’s responses based the combination of the ...

How do I go about getting the programs that are in "programs" to be
alphabetized?  I have Windows ME.   thanks in advance. cl.

Need help trying to figure out how to make a 2 field query showing multiple
phone numbers (home, business, mobile) with the contact ID in the second
field
Example

Simplified, I have one customer table with customer no. and name and one
order table with customer no, order no, valid date from and valid date to.
That means that the order (or contract) is valid from one date to another.
I cannot get a query where I want one row for each customer, ...

I wanna prepare a make-table query. I have a field name with "number of
students". there are values like 0,1,2,3..etc. in it. What I want to do is
that when directly press enter all of the data will come into my screen. in
addition to that when enter 1 and then press enter, data ...

I need to create a primary key field on a table which already has 2500 records.
Is there a way I can filter a query to only return records whose primary key
field has duplicates?
Also is there a way to return records whose character count does not equal 8

I need to put first and last names in an expression.  I have done this but
how do I put a space between the names?

I have a table containing prices for items, linked to a customer database.
One key is CompanyID, indicating what company the spesific price is valid for.
There is a certain basic amount of items that should be valid for all
companies. Theese items is linked to a test customerID.

I have a table called t, it has three fields called CustomerID, DateOrdered,
QuantityOrdered.
Now I want to know how many items ordered totally in each month.
How to acheive this?

I have a sales table that has rolling totals by week (7 days).
Day 1 sales = day 1 total. Day 2 sales = day 1 + 2, etc. I can figure out a
given day's total by subtracting the prior day total from the current day,
except for day 1 which is always equal to itself.

I'm trying to figure it out where I can enter the date myself rather than
using "DATE ()".
1)  I create the queries and it's work but this is not what I'm looking for:
GroupName: IIf((DateAdd("yyyy",1,[LastDayPaid]))<Date() And