CALCULATIONS

[Guest]

I have designed an invoice form linked to my inventary database. I am not
able to calulate. I need to sum few fields, calculate sales tax ( @ %age )
in another field and then total them all in another TOTAL field.

I tried by building an expression, but does not work or show the results in
the respective fields.

Help please by giving step by step each command.

Thank you

Vimal

(e-mail address removed)

 

[RBear3]

What did you put in the controls to perform these calculations? What do
they display instead of the desired results?

If you want to take a look at a working invoice, take a look at the
Northwind sample database that ships with Access. If you want help fixing
yours, you'll have to tell us specifically what you have tried and what the
results were.

 

[Guest]

Thanks for your reply.

I have follwoing fields :

1. Cost of Car
2. Cost of Accessories
3. Documents Charges
4. Registration Fee
5. Sales Tax @7.75%
6. Total Cost of Car
7. Cost of Trade-in Car
8. Net amount Payable by Customer.

To Calculate amount of Sales Tax;
I selected the Design Mode of the Form.
Then brought cursor to Sales TAx field. Opened properties and selected to
build expression by using the wizard: =([1 Cost of Car] + [ 2 Cost of
Accessories ] + Documnet charges])*.0075 and saved.
After entering values in fields 1, 2 & 3, I do not see any result infield 5
and there is no error displayed either.

Similarly I tried to get answer in field 8 by subtracting 7 from 6, but
there is no result nor any error.

Please advise.

Thank you

Vimal

 

[Larry Linson]

In the AfterUpdate of each Control (Fields are where the data lives;
Controls are those thingamabobs on the Form where it is displayed and/or
entered) which is a factor, include a Requery for the Calculated Controls --
that way, they will be re-calculated when any factor in the calculation
changes.

Larry Linson
Microsoft Access MVP

Thanks for your reply.

I have follwoing fields :

1. Cost of Car
2. Cost of Accessories
3. Documents Charges
4. Registration Fee
5. Sales Tax @7.75%
6. Total Cost of Car
7. Cost of Trade-in Car
8. Net amount Payable by Customer.

To Calculate amount of Sales Tax;
I selected the Design Mode of the Form.
Then brought cursor to Sales TAx field. Opened properties and selected to
build expression by using the wizard: =([1 Cost of Car] + [ 2 Cost of
Accessories ] + Documnet charges])*.0075 and saved.
After entering values in fields 1, 2 & 3, I do not see any result infield
5
and there is no error displayed either.

Similarly I tried to get answer in field 8 by subtracting 7 from 6, but
there is no result nor any error.

Please advise.

Thank you

Vimal

What did you put in the controls to perform these calculations? What do
they display instead of the desired results?

If you want to take a look at a working invoice, take a look at the
Northwind sample database that ships with Access. If you want help fixing
yours, you'll have to tell us specifically what you have tried and what
the
results were.

--
Hope that helps!

RBear3
..