count for a report from a query

[taylornow]

I do believe I am just blind today. I have a 4 queries, one for each size of shirt one can order. Each query has 4 columns. One for the first name, one for the last name, one column titled Golf shirt and the last column called Denim shirt. My report keeps showing #err when I try to put a total for each size and each type. The control source for the report is a completely different query, but can't I dcount it from each query for each total? Thanks in advance.

Taylor

 

[JoeMiller]

Yes you can use DCount to count the nubmer of records in another query.. What's the syntax of the DCount statement you're using now? Joe Miller
joe.miller@flotech.net

 

[taylornow]

=DCount("[Shirt Size Golf]","shirt medium query&quot

what am I missing? Have I looked at it too long ?
Thanks

 

[JoeMiller]

There's nothing wrong with that statement, it will count the field name [Shirt Size Golf] in the query named [shirt medium query]. Are those the correct names? If not you'll need to change them to the proper ones. Other things to check are:

a) the dcount control is not named [Shirt Size Golf], (this probably wouldn't cause your error, but it might)

b) the query in question actually returns records, is it a parameter query? if it is the parameters may not be supplied correctly causing your error Joe Miller
joe.miller@flotech.net