strangeryet
Programmer
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
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