PULLING data from other table

See more:

MS-Access

I have two tables:

table one:
origin zip
destination zip
address

table two:
origin zip
destination zip low
destination zip high
cost of shipment


I want all of the data from table one(EXCEPT ADD) and I want the cost from table two if the origin zip code matches FROM TABLES ONE AND TWO. and if the destination zip from table one falls between the zip from destination zip low and destination high. if no match return a blank.

tables looks like this

table one:
origin zip dest zip address
33625 1500 123 park st
33625 2000 123 parl st

table two
origin zip dest zip low destination zip hight cost

33625 1000 1999 $10

return destin zip cost
33625 1500 $10
33625 2000 (blank)





help, still a rookie

help me please!!!!!!