In summary query, there is a where() function, could you give an example to
explain its use
Clara
thank you so much for your help

I need to pull data from 2 queries together for a report, and based on alot
of searching and reading previous posts it sounds like a UNION query is the
route I should go.  I haven't gotten it to work yet, and could use some
guidance.

How can I add new fields in addition to the original fields coming from the
base table using Make Table Query
Clara

I have a question that is annoying me:
If I have 2 tables TableA (Financial Periods) and TableB (Sales). What I
want to do is to return the Period for a given sale date without using a
Dlookup since I have about 1 million records.

In a query with dates eg  SELECT  *  FROM  tblCustomers  WHERE     HireDate
< Date Value
can you use UK format for the date of dd/mm/yyyy or does it have to be in US
format of mm/dd/yyyy.

Hi, this is my first time on here.  I am trying to create a database that
will enable the user to do querries on their product base.  Any given product
has a number of raw materials, which have a solids % (which will need to be
calculated in another table), it will also a ...

Hi
I need to take some data from one table (quiz number and quiz name) and
insert this into another table and then be able to modify that record to
include other data.  I also need to be able to repeat this several times so I

I'm trying to enter a date criteria in my Access 2000 query to return all
records that show a date between 01/01/2006 and today.  The dates entered in
the database are always the last day of any one month, i.e. 31 Jan, 28 Feb,
31 Mar, etc.

Could someone please help me with this.  I would like to set up Autonumber so
that it starts 001001.  I notice that when I try to set this up to append a
query it deletes the first to digits.  I would be very grateful if someone
could help me with this problem.  Many thanks

I have a query that works exacly as expected (Its just a simple select) but
will not work on a collegues. He has the same OS and the same version of
Access, we have the same file structure and all the other quries (some a lot
more complex) work with no problems.

I am trying to write a query for a colleague to pull out some data into an
excel file.
He is using a database which logs enquiries / quotes issued. However under
the detail section of the quote someone hase been entering "As Above" in the

My query looks like this:  [date], [Number], [1st mm taken off], [2nd mm
taken off], [3rd mm taken off], [4th mm taken off], [Exprn1]
I need the [Exprn1] field to return the highest value of all the 'mm taken
off' fields.

I have an unnormalized database that isn't mine - I can't re-structure it.
It contains the names and addresses of all the members of our congregation,
and I've been asked to generate a directory, with the address of each
household showing only once, and the names of the children ...

Is it possible and if so how would I make an update qry not prompt if the
user wants to update the records before doing it.  Basically I want the query
when run to just update the records.

What does this error mean "Syntax error (comma) in query expression
'[tbl_PM's].[DateAdd("m",[Month],[Scheduled_Date])]'?
Thanks
Anna