run a select query during the formatting of a report

J

J

I'm trying to run a select query during the formatting of a report to get
more data form a seperate table. Can you tell me how to best do that.

John
 
D

Duane Hookom

I think the "best" solution is add the "seperate table" to the report's
record source query. If that isn't possible, consider using a subreport based
on the "seperate table". If your "more data" is a single record or value, you
can use a domain aggregate function such as DSum() or DLookup().
 

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

Trying to run a select statement during the execution of a report 1
Report formatting hangs 3
Run select query from VBA code where criteria comes from a multi select ListBox 2
Pull report values in VBA 1
Sharing report formatting with other users? 8
Trouble formatting subform in a report 1
Report using union query 2
Conditional Formatting Problem and #Name? Error 1

Top