calculation done on form to appear in table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

(access2003)
ok, i have 8 checkboxes on a form (option of any 8 wks for a summer camp)
that i wanted to output a sum $ value into a TOTAL box (no need for subtotal
all taxes etc incl)
so i have a calculation on the page as follows (it works)
"=IIf([Check88]=No,0,160)+IIf([Check90]=No,0,140)+IIf([Check92]=No,0,140)+IIf([Check94]=No,0,140)+IIf([Check96]=No,0,120)+IIf([Check98]=No,0,140)+IIf([Check100]=No,0,140)+IIf([Check102]=No,0,140)"
so that the payment amount box automatically calculates the amount oweing if
*any combination* of boxes are checked.

PROBLEM: this calculation is great, but i need the answer to appear/update
on my table as well, so i can generate tax receipts with this amount and all
their information...

thanks, i hope that makes sense
 
mgrimace said:
(access2003)
ok, i have 8 checkboxes on a form (option of any 8 wks for a summer
camp) that i wanted to output a sum $ value into a TOTAL box (no need
for subtotal all taxes etc incl)
so i have a calculation on the page as follows (it works):
"=IIf([Check88]=No,0,160)+IIf([Check90]=No,0,140)+IIf([Check92]=No,0,140)+IIf([Check94]=No,0,140)+IIf([Check96]=No,0,120)+IIf([Check98]=No,0,140)+IIf([Check100]=No,0,140)+IIf([Check102]=No,0,140)"
so that the payment amount box automatically calculates the amount
oweing if *any combination* of boxes are checked.

PROBLEM: this calculation is great, but i need the answer to
appear/update on my table as well, so i can generate tax receipts
with this amount and all their information...

thanks, i hope that makes sense
Click to expand...

You are thinking spreadsheet not database.

In databases like Access you don't store values you can compute. If you
want to see or use the value repeatedly, then create a query and use the
formula in that query. From then on you will have that value anytime you
want, just by using the query.

Normally you should not be viewing data or editing data in the table.
Think of the table as some magical thing the program uses and is not meant
for mere mortals like us.
 
Back
Top