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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pepenacho - 31 Mar 2005 17:53 GMT

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

Reply to this Message

Duane Hookom - 31 Mar 2005 23:58 GMT

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")

Signature

Duane Hookom
MS Access MVP
--

> Hello:
>
[quoted text clipped - 21 lines]
> Thanks,
> pepe

Reply to this Message