Showing selected month & previous 12 months data in a report

[4pbn]

Hi everyone. I have a query that summarizes and sorts data in to different categories by counting records. I show the data for the select month in one report and the previous 12 months data in another report.

I would like consolidate theses two reports into 1 report, by showing in a text box, this month’s data and in a text box and next to it the 12-month view of the data. If either of the two text boxes contain no data and I would like the value to be 0.

Any Ideas

Thanks
Greg

 

[PaulBricker]

If everything is looking good the way it is, I would try to put both reports into a third report as subreports. If for some reason you can't do this, you will need to post a little more info about where the data for your Reports comes from. Do they come from seperate queries. How is the information related? Things like that.

Paul

 

[4pbn]

Hi Paul thanks for the reply. The info comes from the same query. Every month i add data to these tables and present it in a query, so for this month I would have 12 units and the last twelve months 12 + 'x' units. The report should look something like this:
This Month Previous 12 Months
Data Group A 12 12 + 'x'
Data Group B 0 54

I have various data groups that I enter data against and for some months the value is 0, no data. I would like the textbox to show zero as my query does not pick it up.

Regards
Greg Greg