D
Dan
I have a sales database which tracks event based sales. Each event is broken
into classifications of "gold" "silver"and Bronze " depending on event and
expected attendance. The Item sales are summarized into categories of Misc.,
Draft, Wine etc. I have a crosstab query/report which summarizes this:
Category Bronze Gold Silver
Misc $21,071.38 $20,054.32 $18,349.67
Draft $21,104.83 $21,427.45 $19,414.9
Beer $14,200.95 $13,990.02 $12,359.73
Wine $2,092.87 $2,213.50 $1,999.75
Liqour $12,646.80 $13,723.86 $11,131.03
N/A Bev $6,848.30 $6,885.82 $6,142.04
NOw I need 2 things, 1- I need to be able to pull the report based on a date
range. 2 - I need to incorporate total attendance for each class
(gold,silver, bronze) so I can calculate a per cap (avg. of what each attndee
spent while at the event) sales divided by attendance.
Not sure how to accomplish this. do I need a second crosstab for attendance
and create a subreport?
thanks for your help
into classifications of "gold" "silver"and Bronze " depending on event and
expected attendance. The Item sales are summarized into categories of Misc.,
Draft, Wine etc. I have a crosstab query/report which summarizes this:
Category Bronze Gold Silver
Misc $21,071.38 $20,054.32 $18,349.67
Draft $21,104.83 $21,427.45 $19,414.9
Beer $14,200.95 $13,990.02 $12,359.73
Wine $2,092.87 $2,213.50 $1,999.75
Liqour $12,646.80 $13,723.86 $11,131.03
N/A Bev $6,848.30 $6,885.82 $6,142.04
NOw I need 2 things, 1- I need to be able to pull the report based on a date
range. 2 - I need to incorporate total attendance for each class
(gold,silver, bronze) so I can calculate a per cap (avg. of what each attndee
spent while at the event) sales divided by attendance.
Not sure how to accomplish this. do I need a second crosstab for attendance
and create a subreport?
thanks for your help