Access 97 -- Adding numbers in a report

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top