Move Machine Nos to Column Headings

[Dale S]

I have 28 machines where I want to display the machine no. as column heading and sum the production for a week. The database has a column for for the date, machine ID, and production of each product. For each date, all 28 machines will be listed under Machine ID and the number of each product produced will be shown under Production. See example below

Date Machine ID Production
6/1 1 10
6/1 1 15
6/1 2 20
6/1 2 10
6/1 2 20
. . .
. . .
. . .

This is how I want the datasheet to look

Date Mach 1 Mach 2
6/1 25 50

How do I do this?

[pbaldy]

Have you played with the crosstab query wizard?