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
 
You must log in or register to reply here.

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

Similar Threads

Outlook Creating an Outlook form 2
Update table on (sub)form exit 2
Writing VBA Code to compare lines of the same invoice. 1
Percentage deduction Problem in Access Form 3
Complicated Calculations on forms 10
percentage calculation problems 0
how to monitor stock quantity 3
percentage removal problem 0

Back
Top