Query help and averages
Query help and averages
(OP)
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
RE: Query help and averages
Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?
RE: Query help and averages