Rate Look-up

  • Thread starter Thread starter Sammy
  • Start date Start date
S

Sammy

I have two queries: qryShipments and qryShipRates. I
want to look up rates based on country and weight in
qryShipRates and post the rate in the qryshipments field
called RateLookUp. I can't figure out how to construct
my query. Please help.

qryShipments
ID Weight Country RateLookUp
4596 1 China
4597 3 Turkey
4598 2 France


qryShipRates
Country Weight Rate
China 1 $38.76
China 2 $42.52
China 3 $48.38
Turkey 1 $40.40
Turkey 2 $45.59
Turkey 3 $50.78
France 1 $39.30
France 2 $44.06
France 3 $52.80
 
As these are queries, I presume you mean something along
the lines of
SELECT q1.id, q1.weight, q1.country, q2.rate
FROM qryShipments AS q1 INNER JOIN qryShipRates AS q2 ON
q1.country = q2.country AND q1.weight = q2.weight

Hope This Helps
Gerald Stanley MCSD
 
Back
Top