jonnycattt
Registered User.
- Local time
- Today, 16:58
- Joined
- Sep 29, 2001
- Messages
- 20
Hello all.
I tried searching the forums for an answer to my question, but I couldn't find precisely what i'm looking for, so forgive me if this has been answered.
Here's what I have: 5 tables, 60 or so records in each table.
I have a query for each of these tables. The query returns aggregate values: the total number of articles we've edited, the total number of print pages, and the average number of print pages of each article.
What I need to do is create a report that shows this aggregate information for each month (each table is a separate month).
So my results would look something like:
January 60 360 6
February 50 250 5
March 60 420 7
and so on....
i looked at the crosstab query help file, and that doesn't seem like what i'm looking for, nor does a union query. I know joins aren't what i'm looking for.
I'd appreciate any help!
Marc
I tried searching the forums for an answer to my question, but I couldn't find precisely what i'm looking for, so forgive me if this has been answered.
Here's what I have: 5 tables, 60 or so records in each table.
I have a query for each of these tables. The query returns aggregate values: the total number of articles we've edited, the total number of print pages, and the average number of print pages of each article.
What I need to do is create a report that shows this aggregate information for each month (each table is a separate month).
So my results would look something like:
January 60 360 6
February 50 250 5
March 60 420 7
and so on....
i looked at the crosstab query help file, and that doesn't seem like what i'm looking for, nor does a union query. I know joins aren't what i'm looking for.
I'd appreciate any help!
Marc
