matching price to item

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ronmalt@cot.net - 22 Dec 2005 22:49 GMT

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

Reply to this Message

Marshall Barton - 22 Dec 2005 23:53 GMT

>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.
[quoted text clipped - 9 lines]
> 42,300 $5.00
>If I can get to that point I can calculate the totals from there.

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

Signature

Marsh
MVP [MS Access]

Reply to this Message

rkg - 23 Dec 2005 18:26 GMT

Thanks, worked like a charm.
rkg

Reply to this Message