Multiple record sources

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to include more than one record source in one report? I would
like a report that includes two fields that are based on fields from two
different queries, but it's not working. Is it possible?

Thanx,

Ripper
 
You can ...

Use a subreport
or
Use a third query which joins the two existing queries
or
Use the DLookup function
or
Use a custom VBA function that returns the value you want

Each method has its uses under different circumstances.
 
Ripper,
You might want to check the Microsoft.public.access.tablesdbdesign thread
"Set up a report using more than one query" from jbeck2010 on 2/9.
 
Back
Top