If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sales Per caps CrossTab report
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 |
#2
|
|||
|
|||
Sales Per caps CrossTab report
sorry, this was suppose to go in Reports
|
Thread Tools | |
Display Modes | |
|
|