How to group data per month in one page without repeating these data for each column?

[gbab]

How to show data from different queries in a report? With subreports?

Hi there,

My objective is to create this simple report :

January ... June
Sales
...
Revenues

I created a query to calculate these data for each month. I want to show it in columns in my report and I have difficulty to do it.

I understand that the Sales, revenues,...can't be in the Detail Section as they will be repeated in each colunm. So in which section can I put it?

My idea is to create a sub-report that shows the set of data for each month thanks to my query and put these sub reports in colunm. What do you think about it? Do you have any other ideas to solve this problem?

Thanks a lot for your help.

Rgds
Guillaume

 

[gbab]

how to show data from different queries in a report?

Hi,

Following my previous post, how can I show data from different queries in a report?

Thanks,
Guillaume

 

[Mattster]

What did you want the information to look like

Account Jan Feb March April May June
Tom $10 $50 $60 $20 $30 $10
Julie ...


if this is the case I would make up fields inside your system I am unsure how you are storing the data so I would assume that you are date stamping entries
Here goes

January: iif([EntryDate]<(February 1, yyyy) and [EntryDate]>=(January 1, yyyy), [Cost], 0)

And then make one up for each month. With the vague information it is tough to understand exactly what it is that you would like.

Hope this helps

 

[boblarson]

A crosstab might be the answer too. Or, a union query to pull multiple queries together.