T
T-bird
I have another issue, now that I am able to count the number of times a
ticket was purchased 21 days in advance, I need to calculate a percentage of
what that ticket amount is in relation to the total ticket purchase amount
for the division. Such as...
DIVISION TICKET AMT DAYSADV Division Total
CORPORATE $339.70 15 $10191.00
The top lines are field names with the exception of Division Total which is
a text box name that has a calculation of "=Sum ([TICKET AMT]) this text box
is located on sub report named ETSsubrpt1. I hope this is not too complicated
to do. The calculations are done by hand and we have now designed an Access
database to do them but getting all the formulas in has turned out to be
tricky.
ticket was purchased 21 days in advance, I need to calculate a percentage of
what that ticket amount is in relation to the total ticket purchase amount
for the division. Such as...
DIVISION TICKET AMT DAYSADV Division Total
CORPORATE $339.70 15 $10191.00
The top lines are field names with the exception of Division Total which is
a text box name that has a calculation of "=Sum ([TICKET AMT]) this text box
is located on sub report named ETSsubrpt1. I hope this is not too complicated
to do. The calculations are done by hand and we have now designed an Access
database to do them but getting all the formulas in has turned out to be
tricky.