Creating a report

[nebuk89]

Hi Guys
I dont know if I am doing something wrong or if my copy of access is restriced.
I want to create a report from 3 queries, each of these gets data from a table
1. current month
2. last month
3. next month



I want to display these in 1 report but when I try and add them all to the report access has a fit. Should I be getting all the data from one query? Or am I doing something else wrong
Any help appreciated
Many thanks
Ben

[jzwp11]

A report can only be based on 1 record source (i.e. 1 table or 1 query). You either have to combine the 3 queries into 1, or use a main report with an appropriate number of subreports. Why not have 1 query that brings in all three months worth of data and then set up a group using the month() function?

[nebuk89]

Well thats saved me a load of time in report creator at least!!! :P
If I set out below the layout I am after it would be great if you could share your thoughts on it
I have a data set which my current query gets data which matches current month, groups it by user totalling the number of X,Y,Z next to their name
What I am after is

Last Month
X Y Z
User 1 2 3
UserB 2 1 3

This Month
X Y Z
User 3 2 1
UserB 1 2 2

If you get the idea, just to clarify the numbers next to the users are total values for X, Y or Z found
Many thanks for all your help
Ben

[jzwp11]

Can you provide the SQL text of the query, so we can see what you currently have?

You may be able to use the same query to bring in all data and let the report handle the grouping by both month and then user. I assume that you are using a parameter query currently.