Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report based on monthly tables. 1

Status
Not open for further replies.

tcbc

Technical User
Feb 7, 2009
33
US
I am creating a report based on an access database that has monthly data tables. I am not linking the tables and would like to create a report that shows a change in the differences between months and then show a monthly trend. What is the best way to do this. I would like to create a column for each month and then have a percentage showing difference
 
Further, there are two groupings for each month. One for Region and another secondary for Type
 
Use a UNION query:

Select *, 1 as Month From January_Table
UNION ALL
Select *, 2 as Month From February_Table
UNION ALL
...

hth,
- Ido


view, email, export, burst, distribute, and schedule Crystal Reports.
 
Ok.. I know how to make union query. What do you mean by 1 as January and 2 as feb. Do you mean add that as a defining field. so I group by that.
 
Unless you have the full date in each table, you need a column to tell you what month that record is from.

Cheers,
- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top