B
Beth Kevles
Hello --
I'm hoping that you helpful folks can help me out once more.
I have one field (high bid) that's a number entered as data into a
table. Another field (tax) is calculated into a field in a query. (Tax
is either 0 or 5% of high bid.)
My report prints out in order by bidder (these are per-bidder receipts.)
I am successfully summing the high bids for each bidder.
I am successfully summing the tax for each bidder.
I am NOT successfully summing those two sums together to get the amount
of the check the bidder has to write.
I am successfully summing the high bids for all bidders at the end of
the report, so we do know what our school's fundraising auction is
grossing.
I am NOT successfully summing the tax paid, so don't know what size
check the school PTA has to send to the state of Maryland.
I tried to save the tax-sums for each bidder into a variable (using a
text box), but kept getting syntax errors.
I'm sure that this is a simple thing to do, but I need to look at an
example to get it right. (My book on Access 97 got lost in the mail, so
I'm still waiting for a copy. Sigh.)
Thanks in advance for any help you can offer,
--Beth Kevles
I'm hoping that you helpful folks can help me out once more.
I have one field (high bid) that's a number entered as data into a
table. Another field (tax) is calculated into a field in a query. (Tax
is either 0 or 5% of high bid.)
My report prints out in order by bidder (these are per-bidder receipts.)
I am successfully summing the high bids for each bidder.
I am successfully summing the tax for each bidder.
I am NOT successfully summing those two sums together to get the amount
of the check the bidder has to write.
I am successfully summing the high bids for all bidders at the end of
the report, so we do know what our school's fundraising auction is
grossing.
I am NOT successfully summing the tax paid, so don't know what size
check the school PTA has to send to the state of Maryland.
I tried to save the tax-sums for each bidder into a variable (using a
text box), but kept getting syntax errors.
I'm sure that this is a simple thing to do, but I need to look at an
example to get it right. (My book on Access 97 got lost in the mail, so
I'm still waiting for a copy. Sigh.)
Thanks in advance for any help you can offer,
--Beth Kevles