Multi Query report

[blake7]

Hi All, I have a report that is produced from a query, it is running fine but
i would like to add an additional text box on the report to pull the result
from a different query column, is this possible?

Thanks

 

[golfinray]

If both queries have something to key on. Like maybe an ID number or a part
number, something that matches. Then use a subreport and link them using link
master and child fields.

 

[Tom van Stiphout]

On Fri, 8 Jan 2010 04:37:01 -0800, blake7

Sure. Set the ControlSource of that control to something like:
=DLookup("myField", "myQuery")
Check the help file for syntax details.

-Tom.
Microsoft Access MVP

 

[Dale Fye]

Although I use subreports a lot, creating one for a single text field seems a
little extreme.

1. If both queries have a common field to link on, then join the two
queries in the reports record source query and add the field to the reports
RecordSource.

2. Another alternative would be to use something like the following as the
ControlSource for the "additional text box". Although I think the subreport
option would be quicker than this.

ControlSource: = DLOOKUP("SomeField", "2ndQuery", "SomeCriteria")

 

[blake7]

Thanks all, that worked perfect
regards
Tony

On Fri, 8 Jan 2010 04:37:01 -0800, blake7

Sure. Set the ControlSource of that control to something like:
=DLookup("myField", "myQuery")
Check the help file for syntax details.

-Tom.
Microsoft Access MVP


.