using more than one query in a report

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

Guest

I have three queries, each relating to the same field in a table. this
database tracks tons of info on "members". The report I am trying to generate
will print three groups of members, those whose membership runs out in 30
days, 60 day, and 90, days based off of the mebership ends date. I've made
three queries thinking I could join them all in a report but can't see to get
more than one query in a report.
It sees like it should be easy, even for a unschooled novice like
myself, so I am asuming I'm missing something basic... Help.
 
You could
-Join the three queries together in a union query that could be the record
source
-Create three subreports for placement on a main report that has no record
source.
 
You must log in or register to reply here.

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

Similar Threads

Report using more than one queries? 10
more than one table listed in from clause of sql 3
printing report from subform selection 1
Report combiones all records 3
PLEASE HELP: Refresh columns displayed in a report from a query ou 5
Parameters with mor than one crosstab query in a report. 8
Multiple records, multiple queries, one page report. 1
Can't create a report from my query in Access 1

Back
Top