matching price to item

  • Thread starter Thread starter ronmalt
  • Start date Start date
R

ronmalt

I have a query that totals deliveries/customer based on grade and I
need to match my prices from my price table to the proper grade.
Something like this:

Name Grade
Weight Price
Bill Smith #1
50,000 $5.00
#2
37,500 $4.75
Tim Tuttle #1
42,300 $5.00
If I can get to that point I can calculate the totals from there.
I would appreciate any suggestions.

Thanks,
rkg
 
I have a query that totals deliveries/customer based on grade and I
need to match my prices from my price table to the proper grade.
Something like this:

Name Grade
Weight Price
Bill Smith #1
50,000 $5.00
#2
37,500 $4.75
Tim Tuttle #1
42,300 $5.00
If I can get to that point I can calculate the totals from there.
Click to expand...

Create another query that joins the prices table to your
existing query:

SELECT Q.*, P.gradeprice
FROM yourquery As Q INNER JOIN prices As P
ON Q.Grade = P.Grade
 
Back
Top