Summary Count of Multiple Queries (1 Viewer)

N

NavelRing

New member

Local time

Yesterday, 20:07

Joined

Nov 16, 2007

Messages

3

• Nov 16, 2007

• #1

I need to create a report to summarize the record count of multiple queries. For example, Query X returns # records, Query Y returns # records, and so on.

 

KenHigg

Registered User

Local time

Yesterday, 23:07

Joined

Jun 9, 2004

Messages

13,327

• Nov 16, 2007

• #2

You should be able to use dcount().

???

 

N

NavelRing

New member

Local time

Yesterday, 20:07

Joined

Nov 16, 2007

Messages

3

• Nov 16, 2007

• #3

Thanks for your reply. dcount requires an argument based on a field, and I simply need a total number of all records fetched by each query. Count should work better, but I can't get the syntax right to refer to the queries for the totals. Thanks

 

KenHigg

Registered User

Local time

Yesterday, 23:07

Joined

Jun 9, 2004

Messages

13,327

• Nov 16, 2007

• #4

You should be able to use something like:

DCount("*", "Orders")

???

 

N

NavelRing

New member

Local time

Yesterday, 20:07

Joined

Nov 16, 2007

Messages

3

• Nov 16, 2007

• #5

That did it... thank you so very very much!!

 

KenHigg

Registered User

Local time

Yesterday, 23:07

Joined

Jun 9, 2004

Messages

13,327

• Nov 16, 2007

• #6

Cool -
.
.
.