Price Calculation in Access like excel

[racheal.me]

Hi all,

Help me solved my problem with price calculation in Access.

Please kindly view below excel file.

http://www.hwakeat.com/templates/AT05HKGP01/pdf/Products.xls


I like to do formula price calculation in Access like my sample excel file. How many table should I create & How to build query? Whenever exchange rate change or MarkUp price rate change, I only want to type once & it will affect the whole access.

I have tried so many ways in Access but it doesn’t work like my sample excel file.

Please Help me!!

 

[neileg]

You need a table for your product details, a table for your markups and a table for the exchange rates. Then bring your data together in a query or a form and do the calculations there.