Query Formula

J

Janet

I have created a query based on a form and 2 of the fields have several
choices, for example; one field is price level (3) choices and the other is
material (7) choices. I need to be able to create a formula to give me a
material cost based on the material AND the price level chosen on the form..
Any suggestions? I have used Access in the past, but this has mne stumped.
 
M

mcescher

Well if you're just doing some simple math, like multiplication, just
do it in the query

SELECT PriceLevel, MaterialChoice, PriceLevel * MaterialChoice AS
MaterialCost
FROM tblYourTable

If you have more difficult calculations to perform, you can create a
function in a module and then call from your query.

HTH,
Chris M
 
Top