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

 

[DougP]

Is this eventually going on a report?
Its easier to do it there.
=Count(me!textbox)

Queries sometimes won't let you do too much.

DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[Cagliostro]

Does the following one help?
select count(*), t.a, t... from (select a, b, c from x) as t John Fill