in the criteria box what would i type to stop duplicate data from showing up?
field             req #                                site
Date completed
table            material_req                  material_req

Please help!
I have Table A and Table B which are identical in format and content. I
then delete several random records from Table B. How can I make a query
that will compare table A and table B and list the records in A that no

I need code statements that save me two agonizing, finger wrenching
clicks on the mouse to execute the query.
Thank you all so much.
Private Sub Command0_Click()

I am trying to query an Access table but a lot of the fields are blank!
As so in the case of NMBR_HIG_LICENSED_PRODUCERS column for this record.
How do I correctly test for a blank value? Cause I want to make it 0 if it
is./

I not only need the syntax, but I also need to know where to enter the
syntax. Can it be done in the grid view of a query? Or, must I enter it
elsewhere? Exactly where does this need to be entered?
Thank you,

I have a table - tblOrderBoxes, which contains fields OrderBoxesID, OrderNo
and NoOfboxes.  I want to build a query that gives me a string in the format
OrderNo/BoxNo.  I can get it to work fine if it is just one box  using the
following - OrderBoxNo: [OrderNo] & "/" & ...

I have 3 tables that I would like to combine into one.
Table1 contains the following:               Table2
Table3
ProvID         ProvName                             MembName           ProvID

I have been working on another parameter query with a search box.  I created
a parameter query with 7 search fields.  I need the users to be able to enter
parameters in any combination.  If they don’t enter anything for a certain
parameter, I need it to return records even if ...

When I try to insert a tick into the box on an on-line form the box moves to
the right and the symbol inserts before the box.  How do I get the tick into
the box?

Hello everybody - Need help again.
I have a non-normalised (as I believe) database, having three fields (a, b
and c), in which my colleaques record numbers.  How can I find the maximum
number recorded in those fields for each record?

I've created a table containing people's names, addresses, phone numbers,
email addresses and other information. I'd like to be able to create a
query/report to pull a list of specific records from this table. At the time
I run the report I like to input the names of people in ...

I have a text field that I would like to seach and sort from a section of it.
The field looks like this:
First Order:10/13/1999
Number of Orders:86

Hi I have a query in Access 2003 that I am working on that is designed to
bring up all records between week 1 and a user entered paramater week"
between 1 and [please enter end week]".  
Week is derived by usings the following statment in design view of Access's

Here is a query that I am having trouble with. The query selects the correct
data, but what I need is to only show the ZIP that matches in the second
table.
For example, if the [mh zip] is the field that matches in the [dealer sales

I need to learn more about creating queries in Access and I'm wondering if
you all would recomend this book? I need something easy to read and
understand. I have only ever worked with MS Access and not SQL Server. I
have only created databases with Access and would like to ...