Display more than one query

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
 
J

JK

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
 
A

Arvin Meyer [MVP]

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top