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

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
 
D

Duane Hookom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sequentially Numbered Records in a Query, Revisited 2
How to count records using count(*) in a chart report 3
Count records in Parameter Query for Report 3
How do I not count duplicate records in a report 1
Count in a report 2
Query Report group count 4
How can I count unique values in a query in the report footer 1
Count Only Yes checks in Access Report 1

Top