Table made into a Report 1

[4Wile]

Table name: Item
Field names: Description, Year, Week, Cost
Report name: Cost per Week

Sample Report: Cost per Week
Popcorn Week 1999 2000 2001
1 1.20 1.46 1.15
2 1.19 1.46 1.14
Etc.
Candy 1 1.00 1.25 1.12
.
52 Etc.

The Tables sorted Description, year, week

 

[petermeachem]

do a crosstab query to get the data using the wizard. Use the report wizard on the crosstab Peter Meachem
peter@accuflight.com