irishcavan
Registered User.
- Local time
- Yesterday, 19:34
- Joined
- Nov 2, 2005
- Messages
- 15
I have a math problem for you. I have tried to write the code a couple of times, but to no avail.
Here are the details:
Item 1: $ 02.65 - mark up 150%
Item 2: $ 15.85 - mark up 75%
Item 3: $ 62.58 - mark up 25%
Final Dollar figures need to be rounded up to $ xx.95
I have the calculations working in Excel, but I want them to calculate in the database. I have a column for each parameter(ie. 0.00 - 10.00, 10.01 - 50.00, 50.01 - 100.00). But, I am not quite grasping how to tell Access to calculate off a range of pricing to give me the correct dollar figure.
Here is the calculate that I have in Excel: =SUM(ROUNDUP((IF(J5<10,(SUM(J5*400%)),0.00)),-0.01)-0.05).
I would like to be able to have the final dollar figure saved in the table if at all possible, if not - then just for viewing and display on the report.
Thanks,
Irish
Here are the details:
Item 1: $ 02.65 - mark up 150%
Item 2: $ 15.85 - mark up 75%
Item 3: $ 62.58 - mark up 25%
Final Dollar figures need to be rounded up to $ xx.95
I have the calculations working in Excel, but I want them to calculate in the database. I have a column for each parameter(ie. 0.00 - 10.00, 10.01 - 50.00, 50.01 - 100.00). But, I am not quite grasping how to tell Access to calculate off a range of pricing to give me the correct dollar figure.
Here is the calculate that I have in Excel: =SUM(ROUNDUP((IF(J5<10,(SUM(J5*400%)),0.00)),-0.01)-0.05).
I would like to be able to have the final dollar figure saved in the table if at all possible, if not - then just for viewing and display on the report.
Thanks,
Irish
