run a select query during the formatting of a report

  • Thread starter Thread starter J
  • Start date Start date
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
 
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().
 
Back
Top