After developing my database for one specific reporting requirement I've now been asked to produce a series of reports all following the same basic structure, but I'm struggling to make sense of it (maybe I'm just too close to the old reports).
Simplistic version of main table (tbl_DeptSales)
Dept: 1,2,3,4 etc
Quarter: 02/03 Q1, 02/03 Q2. 02/03 Q3, 02/03 Q4 etc
Sales: a, b, c ,d etc
Now I've been asked to produce a report of percentage sales increases based on Q1 of each year, ie
Q2 Sales for Q2/Sales for Q1
Any advice?
Narked Pol
Simplistic version of main table (tbl_DeptSales)
Dept: 1,2,3,4 etc
Quarter: 02/03 Q1, 02/03 Q2. 02/03 Q3, 02/03 Q4 etc
Sales: a, b, c ,d etc
Now I've been asked to produce a report of percentage sales increases based on Q1 of each year, ie
Q2 Sales for Q2/Sales for Q1
Any advice?
Narked Pol
