report from two queries?

[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

 

[Duane Hookom]

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

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?