Counting records in a query.

[prodtest]

I have a table as below:

Serial No Date Manufacturer Engineer
=========== ========== ============ ========
68701/12345 05/05/2005 TIS Robin
68709/00256 01/04/2003 MPE Robin
68707/44589 09/12/2005 TIS Colin
68701/12587 05/10/2004 TIS Mike
68709/00045 12/03/2003 MTEK Colin
68700/30649 05/05/2005 TIS Ben
68703/00005 05/10/2005 TIS Robin
etc ......

I have also created a query which seperates out items whos serial no's start the same.
i.e all items with serial no's being 68701
I used the LIKE command in the creteria field of the query to sort that out.
But I need then to be able to count how many items in that query begin 68701 and display it in a box.

Any help greatly appreciated on this one.

Ben

 

[PHV]

You may consider the DCount function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lespaul]

Why do you have to run two queries? Could you post the first query?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual