I have a table T1 with a key-field.
I also have a query Q1 with the same key-field. Q1 is not based on T1, but
some other tables and queries.
Now I want to delete all records in T1 that are not in Q1.

I have a form that i use to filter a tables records by select query. The
form has ten fields but I sometimes only require to filter on two or three
fields yet I sometimes need all of them. If I leave the fields blank then
the query obviously looks for blank entries and finding ...

I am trying to create a crosstab query. I have created 53 column headings
with week numbers 1;2;3;4; etc.
I would like the blank values to have 0. I have tried nz but this doesn't
work. The format 0;0;0;0 does work, but not when I import the query results

i have a query and form that i setup. They query/form has 10 check boxes and
10 fields that display a value if the check box related to that field is
selected. I now want to able to setup a check box that will select all of the
other checkboxes at once if all the criteria applies ...

I need to be able to run a query whereupon each time it is run, new
data that matches criteria is added to the end of the existing query
with a date when it was added.
Is this possible ? or is there a better way of doing the below..

I made a union query that I then display as a cross tab. It seemed to run
normally but the figures didn't look right. By running the query only, I
realized that it only retrieves 1000 rows. Is there some settings that I need
to change?

I have two tables, one with two fields, the second also with two fields with
one of fields being identical to the first
one field is a text field the second is an integer field
I wish to create a query that retrieves that retrieves the text field from

I hope some i can help me i have a table full of access codes so i need a
query where i can say take the next 20 records out of that table and move
them to a diffrent table.
Regards

I want to be able to allow teachers to select from a list of 20 possible
student needs. I propose have a table with 10 fields with a combo box for
selection and the fields used would vary from 1 used to all 10 fields. I wat
the report & Possibly the query to only show the used ...

Hi all..
 Ok I have been banging my head for two days trying to do this...  There
has to be an easy way of doing this.
 I have two tables...  exactly the same except for the info contained.  

Using Access 2002, would like to query a database for birthdays in a specific
month.  I already know how to get birthday's based on today's month (+1 or
-1, etc.) but I want to specify which month by entering the month number in a
parameter window.

Folks,
I have a problem whereby I can run the following query in Access 2000 and
get results, but when users using 2002 run the same query - they get no
results in the query. I have narrowed down the problem to the data range

Hi. I have a query with three tables. Two of the three columns are shown
below, the third being similar to the second, so I'll leave it out:
1.PlanTypeID
2.MTD:

Okay, I have posted my question here on two previous occasions, and either
I'm doing a terrible job of explaining myself, or the people who have read my
posts are extremely busy and didn't have the time to read and understand my
post. I also admit that I am SQL ignorant, and ...

Just joined this forum and posting my very first thread.. ^^
I need to create query to pull data from two different tables. Thi
should be really easy query for most of you. Once someone help me se
it up, I can do the modifying.