G
Guest
The aim of my first database is to be able to produce a number of reports
that will give comparison data over a period of 5 different years for
different groups IE Districts Regions ETC
The report in theory would be be in landscape format and would have five
column headings IE Sales 2004/05 sales 2003/04 ETC.
I have two tables one giving basic details of shops IE Store number
(Primary), address, district,Region. This is my main table .The other table
gives details of sales over the five years for each shop on a monthly basis.
The main table has a one to many relationship with the child table based on
the store number.
I need to produce reports that can give comparison data over 5 years based
on districts and regions.
My question is what sort of query would enable me to extract the required
data so that i can be put it in the reports based on my tables or do I have
to restructure my tables so that I have a different child table for each year.
that will give comparison data over a period of 5 different years for
different groups IE Districts Regions ETC
The report in theory would be be in landscape format and would have five
column headings IE Sales 2004/05 sales 2003/04 ETC.
I have two tables one giving basic details of shops IE Store number
(Primary), address, district,Region. This is my main table .The other table
gives details of sales over the five years for each shop on a monthly basis.
The main table has a one to many relationship with the child table based on
the store number.
I need to produce reports that can give comparison data over 5 years based
on districts and regions.
My question is what sort of query would enable me to extract the required
data so that i can be put it in the reports based on my tables or do I have
to restructure my tables so that I have a different child table for each year.