Debit Money Checkbox

  • Thread starter Thread starter Dan Lavish
  • Start date Start date
D

Dan Lavish

I have a quality database that i created to keep track of dmrs ncrs
ect I keep track of the total cost of all the dmr's on the bottom of
the form with the control of =sum([total_cost]) on each dmr their is a
total cost of the dmr what i want to do is have a check box at the
bottom that if checked it will subtract the money on that dmr from the
total amount of the dmrs preferably a separate text box if anyone
could
help me with this code that would be awesome

Thanks, Dan
 
You can use the DSum function to total dmrs for all records. Help has more
information about DSum. Without knowing anything about the database
structure it is difficult to offer a specific suggestion. It could be as
simple as:
DSum("[dmrcost]","[TableName]")
However, if the total is derived from several cost fields it should not be
stored, but rather calculated on the fly. DSum, then, would use the
calculation in place of [dmrcost].

BTW, it is difficult even to understand a question that is not punctuated.
 
Back
Top