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

 

[Psychpt]

in your query just add one more column with the count, eg.

SELECT ............ Count(*) AS TotalRecords FROM ...... WHERE ...... ;

HTH

PsychPt@Hotmail.com