run a select query during the formatting of a report

[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

 

[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().