I have the following group of 4 nested queries, the 2nd of which (and
therefore the 4th, on which a number of reports are based) runs very
slowly - around 60-80 seconds. The largest table [x confirmed] contains
around 20,000 records.

In my application I have a form with a combo box. What I want to do is select
an item from the combo box and have that item removed without deleting it
from the table bound to the combo box. I inserted a check box in the table
and created an update query to remove the item from ...

I have a data base with 3 tables. I have 5 records in each of the tables. I
wrote a query and when I run it I get not record data.

I want to be able to auto generate a form letter/email based on data in my
database.  We are rolling out a new POS system for our company and I am in
charge of making sure it all goes well.  My database has a number of fields
in it, the one in particular is "Install Date" which ...

I have a query that returns 2 date colums, target date and actual date.
Either or both may be null. I need a query to load a list box and it must be
sorted in ascending date order with the blank dates last. For sorting the
dates the actual date if present overrides the target ...

I am having problems with a delete query that has an inner join. I have two
table related to each other by a field SERIAL_NUMBER. I am trying to delete
records from one table based on criteria in another and I can't seem to get
it to work. Basically this is what I would like to ...

Is there a way to write a parameter query using "greater than" rather than
"between... And..."?  I tried using " >[greater than:] ".  It produced a
query, but with erroneous data.

I'm building a subscribers database for a client. There are six
different categories. 0 to 6. I need to return those names that are
subscribed to ALL 7 of the categories. He/She cannot show up if, say,
he/she is subscribed to 5 categories. It needs to be a query so that

Hope I can explain it. Is there a way to ONly select part# If only it meets
the 3 regions.
Example,
PARTNUMBER    REGION

have four command buttons set up on my input form: NEXT | PREVIOUS | FIRST |
LAST - below is an example of the click event code for the Next button - the
user gets error messages if they are on the last record and they then click
"NEXT" or if they are on the first record and they ...

Right now I have a parameter query where the user enters a start and end date
of a week and it finds all records in that week.  I need to make another
query that will find all records from the week before those records that are
in the first query.

i did a iff ( if x value = x value,Y,N) then i tray to use"Y" like a criteria
in the colum. When i run the qry i get the message  "enter parameter value"

I'm using Access 2000.  This is a simplified version of what I have.
Student Table
Student ID  Name  Grade . . . . and so much more
1                 Cindy   12

Need Help.
How do I tie a macro executed from a button on a form to the current record I
am looking at in that form?
I have a form that shows all the fields for a singe record from a sales table.

I work for an engineering firm.  Each engineer works on different projects
each month.  However, not all projects will have time spent on everymonth.  
Sometime, they spend time on one project for this month and then next month
they don't have any time on that same project, but ...