I cannot append new records on query once I have linked 3 tables.  I cannot
get to the new reord at all.  The entire query from table is read only and
not editable.  It allows to enter if I link two tables.  Please advise if I
can fix this.

I need a query that results all records that contain for exsample LS in
field1  twice.
Even if this LS is in table only once.
Like this:

I am creating a query for a commissions database that will give me a list of
payments that is due within a specific time period.  I have a
FirstBillableMonth field that gives the date of the first invoice and a
DueDate field, which is a calculated field, that calculates when the ...

I want to print labels from a table that contains the info I want
printed. I customized the label sizing to match the sheet of labels I'm
using. There are 8 columns on the page. The labels are
1" x 1" with no space between the labels either horizontally or

I am trying to run a query were I have one field that contains over 100
different type of service calls.  I want to exclude certain calls.  I tried:
Not "Voided Record" or "Lunch"
but it still showed lunch calls?

I want to create a new table with the contents of 2 other tables whose
design specs are the same.
What would be the syntax to do this?
Right now, to get 1 query's results into a table I do something like:

I have a query that uses the expression below. As it is, it shows active
patients who have an appointment within the date range the user enters, but
drops the patients that don't. I need it to always show ALL the active
patients, but indicate that they have no appointments in the ...

I know there is a way to list the fields in a query, but I can't quite get
the code right. Can someone please post a way to do this?
Actually, what I am trying to do is check to see if a column exists in the
query.

All,
I was hoping that someone might be able to give me some guidance in how to merge two records into one in a query. By that I mean in my table I have two records that have the same mailing address but are different records :
ID, First Name, Last Name, Address
1, Susan, Jones, 1 ...

I have a table detailing customer's visits to an office and their activities.
Each record has a customer ID field, visit date and activity code. In each
date, a customer usually has some activities in the office, therefore each
visit to the office is represented by 5-10 records, ...

I am using Access 2000 and I was wondering how to write a query on a date
field to find all records within the last 30 days.
I tried Date()-30 and it didn't work.
Any suggestions?

I really need to uncover the answer to this question rather quickly. So
anyone who can help with this please do so right away.

i'm looking to find the top 5 sales by salesmen for each item sold.  below
is my query - it is returning just the top 5 salesmen.
any help would be appreciated:
SELECT TOP 5

I would like to run a query based on the result of a combo box.
For example, in a form I have a combo box to select a road name.  When I
select a road name I want a query to run in the afterupdate. I don't know the
codes for this.

I am creating a query that only shows records where the last two digits of
one of the fields is between 00 and 49. Any suggestions on how to word this
criteria expression would be appreciated.