Report based on monthly tables. 1

[tcbc]

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

 

[tcbc]

Further, there are two groupings for each month. One for Region and another secondary for Type

 

[IdoMillet]

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.

http://www.MilletSoftware.com

 

[tcbc]

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.

 

[IdoMillet]

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.

http://www.MilletSoftware.com