Trying to combine reports

[mdwilcher]

Thanks in advance for all of the help I receive.

I am trying to combine 3 reports into one. I tried using the Subreport function, but the information on the last 2 reports is being pushed into the Detail section of the main report. I tried to separate each by using a Section Footer, but that didn't work. I am trying to sort by date, i.e. all records in the last 30 days, all records between 30 and 90 days, and all records older than 90 days. I have all of the data, but I really would like to combine these three separate reports instead of one main and two subs. Any suggestions?

 

[Smart]

you could create a new query and add to it each query that the reports are based on (don't forget to link the queries)

Then use this new query as the source for the report

 

[mdwilcher]

Thanks for your help. I tried that method. The problem is that all of my queries are based on the same fields in the same table with the same Join properties. The only difference is date. Getting the data is not a problem. I basically need to show records from three date ranges in the same Detail Section, and I need to differentiate between the three, i.e. a heading for each section.