Dumbest question of the day!

[adamburton]

Okay, here it is - the simplest question which you will answer in a second Im sure!

Ive created 4 queries (mostly count queries) and have created a report to incorporate them into. but i cannot for the life of me remember how to reference the individual queries in my report. Ive set up a number of text boxes for the data i need and put in something like:

=[qselRiskCalc4]![No of Risks]

...into the control sources, to pick up the data I need from each query. but i keep getting an annoying #Name. Any suggestions?

Thanks,
Adam.

 

[Mile-O]

You are probably after the domain aggregate functions.

ie. DLookup, DSum, DAvg, etc

All the info is in the Help files.

 

[KeithB13]

Another angle...Try combining all 4 quries into one query..ie..query your querries. Use the new query in your report.

Good Luck,
Keith