Query help and averages 1

[strangeryet]

I have a table with rows that contain a Date, Id and an amount.
I need to create a report or form that will show each ID with the same Date the amount and an average for the amounts.

A table example would be:
Date......Id..Amount
4/12/2012 123 4
4/12/2012 456 3
4/12/2012 789 2
5/12/2012 123 5
5/12/2012 456 8

The returned report or form would look like:

ID...4/12/2012....5/12/2012.....avg
123......4...........5.........4.5
456......3...........8.........5.5
789......2...........0.........2.0

is this possible? I've heard of a pivot table? but never used one.
the number of date headings would depend upon the number of records with different dates.
Thanks

 

[PHV]

Create a CrossTab query (you may use the Wizard).

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[strangeryet]

That may have done the trick. Thank you