View Full Version : Total for Query


sdkramer
03-19-2002, 08:33 PM
I've made 2 queries, and I'd like to find the number of records that the queries result in, for a report, but I can't seem to get the syntax right. Lets say I have 2 Queries called qryA and qryB. In my report I currently have the following, and it's not working:

=(Count(qryA![Name]))/(Count(qryB![Name]))

Note: qryB is not empty.
I just get #ERROR

Any ideas?

Thanks

DES
03-20-2002, 02:03 PM
try

=DCount("[Name]","qryA")/Dcount("[Name]","qryB")

sdkramer
03-20-2002, 04:38 PM
Yes, That worked perfectly. Thank you so very much.