Is it possible to get a drop down menu of options when doing a query search?

Hi, I have two tables, where the child table has two primary keys to link it
to the parent table. I'm trying to create an unmatched query where it will
find any records on the parent table that don't have corresponding rows on
the child table, but I'm stuck. Does anyone have some ...

I have tables, forms and reports set up in my database that work perfectly to
track vacation days taken. The problem is in order for the report to look
right I have to put in each day separately.
Is it possible to enter a range of days ex: start: 05/13/08  End: 05/31/08

I have a table like this:
tblEACodes:
==============================
SK    AQ_FKEY   aqeEA_FKEY

Help! I have two tables, one is a "master list" and the other table has most
of the files that is in the master list. Is there anyway to extract those
files that are duplicated in both the master list and the other list while
leaving the other files remaining? If anyone could ...

I also have duplicates in my Database and have entered the following for:
- PrimaryID   = ID1;
- Table Name= TEST_MBS2;
- Duplicate is defined as the same ID, LAST NAME, FIRST NAME, AMOUNT, and

How is it possible to merge 2 different tables together.
Table1 has AddressID, ApptNum, ApptDate, CompletedDate
Table2 has AddressID, NANum, NADate, CompletedDate
I want to merge into

For example if the values are:
1,1,2,3,4 then return 1
1,2,2,3,4 then return 2
1,2,3,4,5 then return 2

I have a date field "daterecieved" i would like to query for items over 30
days old where a completed field is null. Please assist.
Thanks

Here is the query.
SELECT Nz(Count(a.com_num),0) AS Total, a.com_type
FROM a
WHERE (((a.date) Between forms![date range]![Start Date] And forms![Date

I've got 2 fields in my database that represent Easting and Northings.  Due
to the way the client's db is set up, I need to append each of these values
to one of 2 fields in the destination table (UTM_Easting or Grid_Easting).  
UTM's are the full 6/7 digits while Grid coordinates ...

I am using Access 2003
A couple of years ago, I created a query to append employee files from my
active Db to a Retiree Db.  I need to do this again and want to use the same
query.  But the name of the Retiree Db has changed.  How do I change the

Is it possible to make a passthroguh query updatable?
I think that it normally isn't because it doesn't know the primary key, but
is there a way to specify it?

I am trying to do an update query on 07-09 A2 from 07-09 A. Both are date
fields on tables. The only problem is there may be 2 or 3 records that have
been changed this year and it wants to update all 90 records. I tried in the
criteria Between 1/1/2008 and 5/13/2008 but it still ...

I know this is simple to do, but can’t seem to do it correctly!!
I have a “final_status” variable field that contains values such as “active”
“complete” “patient refused” and “doctor refused.”
I want to re-code or re-group these into 4 new variables.