Help!!! Newby at the keyboard

  • Thread starter Thread starter Roger
  • Start date Start date
R

Roger

Hi - I have a little experience in creating simple
databases but am stuck on this.

I need to create a form where the user will input a Value
(eg: invoice amount), below Add another field to input a
value to be deducted from the invoice amount.

That part is easy the difficult part is to add a field on
the report which will show the calculation of the 2 fields
automatically. Be aware the deduction will not always
happen, so a trigger like Lostfocus may not work.

Please help as i am stuck and tearing whats left off my
hair out ....

Thx

Roger
 
Hi there
Add an unbound text field to your form, and in the data
source property of the new field enter your equation
([InvoiceAmt]-[InvoiceDiscount])

hope this helps

Paul
 
Back
Top