Morning, we have 5 offices throughtout the state which use daily an
append query to update a Master Table in Austin.  We need to find a way
to flag the records once they are appended to that table to prevent
appending them again later.

When I try using a form to select from a table drop down list for the Query
Criteria, I get "Enter Parameter Value".  I have checked and re-checked the
Controls.  This happens even with the Northwind Sample database when
following the "Office Online Assistant: Using parameters ...

I have a database which has a lot of information which i dont want to see.  
For example:
Expr1: Format(([TIME]>=60)*-1)  
This will then put a "1" in all the fields where the time was greater than

I have a report and use two queries as subreports. The queries are setup
to ask for start date and end date parameter info. When I run the report, I
am prompted twice to enter the same info for each subreport. I only want to
be prompted once and use those values for both ...

This is doing my head in as a newbie to Access
I have a QuoteItems table that has a [Item] and [Qty] field and gets
populated automatically from another source.
The above causes Item duplicates in the table. What I need is some help on a

Is it possible to combine the following three queries into a single object in
Access, saving keystrokes of having to run three separate queries?  
UPDATE TempTbl SET Proctype = 'Encounter'
WHERE Proc IN ('a','b','c');

I have a table with a list of IDs. I need to produce a query that takes the
matching IDs from tables 2 and 3.
For example
Table 1                     Table 2                   Table 3

I have two fields (Student Name and Homework Type) in Table A.  Table A may
contain more than one homework type per student.  There are 4 different
homework types.  
I also have Table B.  Table B contains 5 fields (Student Name and 4 Homework

Is that possible to put "two statement" in a IIF statement?
I want to put IIF(q6a = 0, 'yes' AND q6c = 'N/A') like this?
In my table, the q6a and q6c has values 0 or 1.
0 means YES or N/A

I have a database with a field for date of birth and I want to be able to
calculate age.  What is the function / expression for this?  I am a
sophisticated user but do not do visual basic so I would prefer a solution
without having to use VB.

Here is my situation.  I have a list of 765 clients who called in to my
centre on sept 8.   Out of that 763  - 65 calls were placed for a specific
product.  Those 65 calls were placed by 38 clients.   I am trying to run a
query to show just the 38 clients, but the duplicates ...

Is that possible to put "two statement" in a IIF statement?
I want to put IIF(q6a = 0, 'yes' AND q6c = 'N/A') like this?
In my table, the q6a and q6c has values 0 or 1.
0 means YES or N/A

I know it is possible to create an update query to update one value in
one table based on the value from another table.
But it seems it doesn't work if you wnat to update multiple values.
My goal is to update multiple fields in one record of TABLE2 with

I'm working on a property management database and would like to query store
opening dates to show which fiscal year they opened.  Our fiscal years are
month/day years.  Example:  FY 2005 was 10/04/04 – 10/02/05.  How can I
calculate these dates?  There are over 100 stores with ...

I have a make table query that I execute throught VBA, it is used to base a
report on and it runs fine, the table is okay and the data spot on.
Next time the report is run, the code searches for that particular table in
the Tabledefs collection to delete it prior to running the ...