[AccessD] Days of the Week Report

Hi:

I know I'm missing something, but I currently can't get the following to
work:

1. tblProductionInfo has the following fields: (ProductionID, DateProduced,
KgsProduced, BatchSize, BagsProduced ... Etc.)

Basically, I want to be able to display a report with the days of the week
at the top (column headings), and the fields (KgsProduced, BatchSize,
BagsProduced) as row headings. 

Thus, it should look something like:

			Sun	Mon	Tues	Wed	Thur	Fri	Sat
KgsProduced		1	3	3	2	2	2	1

BatchSize		1	3	3	2	2	2	1
BagsProduced	1	3	3	2	2	2	1
Totals		3	9	9	6	6	6	3

Can I do this in Access? I'll be using a parameter in the query to select
only one calendar week at a time using the DatePart and Year function to
filter against user supplied criteria. 

Any hints would be appreciated ... Haven't worked with Crosstabs in a long
time ... I know it has to be easier than I'm making it !

Larry Mrazek
LCM Research, Inc.
www.lcm-res.com
lmrazek at lcm-res.com
ph. 314-432-5886
fx. 314-432-3304