Help!!! Newby at the keyboard

[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

 

[Paul Falla]

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