Math

  • Thread starter Thread starter DaveB
  • Start date Start date
D

DaveB

How do I make a math formula that will add up other
fields? I'm not sure where to even do this. Is it in
properties?
I have 8 fields; (Product, Unit Price, Quantity, MarkUp,
Customer Parts), Labor and total. First I need to tell
the MarkUp field what the MarkUp is, which would be 15%.
Then I need to take the unit Price and multiply the mark
up, (as a percentage of 15%), and then multiply that by
the quantity to get the Customer Parts (Price). Then I
need to add up the Customer Parts & the Labor Price to
get the total field. Please tell me simply,in beginners
language, how do I do this?
 
Dave,
You ask a broad, complicated question. Suggest you look
at the Northwind sample database that came with Access.
Start with the Orders and Orders Subform, working backward
to the underlying queries and tables. It appears close to
what you want to do.

By the way, you do calculations in queries and you
generally do not store calculated values in your tables.
Build your forms and reports on the queries and let Access
recalculate each time. Also, looking at both of your
posts, do not store the same value in different tables.
That defeats the purpose of a relational database.

Roxie Aho
(e-mail address removed)
 
Back
Top