Report using more than one queries?

[knavlekar]

Hi !
I am a very basic user of Access. I want to know can we run a single report
using more than one queries?

one field coming from one query and other fields from another query.

Thanks in advance.

Regards.

 

[Duane Hookom]

A report has only one record source. You can try to combine your queries
into a single query or use subreports or use DLookup() or use code to pull
values from other queries or tables.

 

[knavlekar]

Thanks.

I want to display a field on a report that is not coming from the report's
record source. Instead it is coming from a parameter query (the parameter for
the query is coming from the same form that report record source is getting
its criteria). I think Dlookup () function can not be used for a parameter
query.

Any other options for that?

regards.

 

[Duane Hookom]

Use a subreport based on the "parameter query".