Report using more than one queries?

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

Guest

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.
 
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.
 
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.
 
Thanks for your suggestion.

I am trying subreport using a parameter query. when I run the query
separately for the testing sometimes it asks for the parameters and sometimes
it shows result with no data init without asking the parameters? what might
be the reason for that?

If you want I can send entire database so that you can check it out. If so
then please let me know your email address so that I can send entire database
to you for testing.

Very best regards,

kedar
 
I never use parameter prompt queries. I use references to controls on forms
for criteria. Try do the same to clear up some issues.
 
Thanks for the website name.

I could not found any form control suggestions on that site.
It was really helpful to clear some other doubts.

any suggestion?

regards
 
Back
Top