enter data in access

  • Thread starter Thread starter The bard
  • Start date Start date
T

The bard

I have created an invoice form in Access2007. All the items are sub totalled,
carriage added, vat calculated and then grand totalled. How do I manually
enter the carriage charge in to the form so that it is 'picked up' by the
calculation (vat = (subtotal + carriage)*.175). At present I can enter
carriage, but it is not recognised in the calculation.
 
At present I can enter carriage, but it is not recognised in the calculation.
Is the textbox the Carriage is entered bound to a field?

What type of object is your formula (vat = (subtotal + carriage)*.175)
entered?

You did not mention anything about your table structure that contains the
data. What does it look like - table & field names and the datatype.
 
The textbox is not bound. All other items are set up in a table and work ok.
I cannot set 'Carriage' up in table as this is not known until goods are
shipped, so needs to be entered manually.
 
Seems to me you would want to record Carriage in your database otherwise how
do you look it up - search a paper file?
I asked two more questions that you did not answer. Need input.
 
Back
Top