What I have:
A table with the fields as described below:
Product ID, Description, Cost, Price1, Price2
What I want to do:
1. I want to create a calculated field in a query that will meet the following criteria:
Price1= cost * 4.2
Everything is rounded to the nearest $5.
If the result is less than $5, the minimum charge is $5.
If the product id starts with "X" (it could be X3000-S090-B or whatever the case might be), the minimum charge is $25.
Price2 field has the same requirements, just a different markup like 5.6
2. Make a new table with the results above in a separate query