Creating a report from two different parameter queries

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

Guest

I am trying to create a report using two different parameter queries from the same table using the report wizard. When the report is run, I am prompted to enter the values in the parameter box. The report comes up blank, and I know the information entered is correct. I can run the queries separately and they work just fine. What gives?
 
Shane

Do you mean you have two separate queries, and you are trying to include
fields from both of them in the same report? This is complicated. It
could be that even though there is data retruned by each of the queries
separately, the combination will not work. Can you make just one
suitable query that can be the record source of the report?
 
Having just one query may prove to be just as difficult. I may have to add addition table fields to query the data in a meaningful manner to accomplish the report with one query.
 
Shane,

Well, there's your answer in a nutshell. If it's too difficult for you
to figure out how to make the record source for the report, how can you
expect Access to automatically get it right?
 
Back
Top