Display more than one query

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

Guest

Hello,
I have an access table and I have four queries I run off it. Each query
pulls some different information off, but each query requires two dates to be
input. What I would like to do, is to display the results of each query, all
of them on a single page. The query results are not large (only a few lines),
so they will fit on one page. What would be even better would to be just have
one query which would pull off the information in one go, but as the query
results are not related, I don't think that this is possible.
Thanks
 
You can do it in one query,

You will need a common field in both tables. Create a query, bring both
tables into it, link them on the common fields and select all the fields
that you want in the query from both tables.

Regards/JK
 
You can display the queries using a subform or subreport. If there is no
common key fields which link them, you simply need to make sure that none of
them use a link to either each other or the main form.
 
Back
Top