report from two queries?

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

Guest

I have a report that is pulling from query A. I want to add a text field at the bottom of the report to pull a value from Query B. Can this be done or am I going about it the wrong way

Thank
Lanee
 
You can use a text box bound to an expression like:
=DLookup("[yourfield]","[YourTable]","your where clause")
or you can use a subreport
or you can use code to place a value in an unbound text box

--
Duane Hookom
Microsoft Access MVP


Lanee said:
I have a report that is pulling from query A. I want to add a text field
Click to expand...
at the bottom of the report to pull a value from Query B. Can this be done
or am I going about it the wrong way?
 
Back
Top