Counting records from a query...

[dodgyone]

I have a series of queries which give results depending upon certain date. From these I create charts etc.

What I would like is to count how many records there are once the query has completed (the date criteria is not fixed so the query requests the dates as you start it up). I would then like to be able to place this total in a table, in a certain row.

Is DCount the best options... how does it work etc?

Thanks,

Marcus

 

[jimmythegeek]

This is the DCount function. Just change the values appropriately. The first "Shipped date" would be the field you want to count, The "Orders" is the name of the table, and the second "ShippedDate" is the criteria.

x = DCount("[ShippedDate]", "Orders", "[ShippedDate] = #1/1/2001#&quot

You could also use between:

x = DCount("[ShippedDate]", "Orders", "[ShippedDate] Between #1/1/2001# AND #1/31/2001#&quot Jim Lunde
compugeeks@hotmail.com
Custom Application Development