Report based on a query: need to plug in a count from a different

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:

I have

ReportA
qryA
qryB

ReportA is mapped to qryA. It has a report footer with some sums and counts
based on fields in qryA.

I have some related information in qryB. I'd like to include some Counts in
ReportA.

It seems that it can be done with a function of the type
=Count([qryB]![customers])

however this fails.

Is there a reason why? Without joining tbls or qrys can one pull this off?

Thanks,
pepe
 
There is a good reason why it fails. You can't use a sql statement or
external table/query/field name in a control source. You can use something
like:
=DCount("Customers","qryB")
 
Back
Top