Query Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subtotal group records in Access 2007 3
calculated sum in subform footer problem 1
Calculated field in main form 4
Calculated Fields 4
MS Access "VALUE" Function 1
v look value dependant on 2 cells 4
How To make condition in SQL query statement 1
Lookup Price based on two values 2

Back
Top