Total for Query

[sdkramer]

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]

try

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

 

[sdkramer]

Yes, That worked perfectly. Thank you so very much.