enter data in access

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.
 
K

KARL DEWEY

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.
 
T

The bard

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.
 
K

KARL DEWEY

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.
 

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

Top