Query similar to vlookup (true)

[paulogeneroso]

Hello Everybody!!!

I need a help.
I have one table that has a field called "Initial ZIP CODE", another field called "Final ZIP CODE", and a field called "AREA".

I have a data base that will give me the specific "ZIP CODE", that will be between the "Initial ZIP CODE" and "Final ZIP CODE", and I want to get the "AREA".

Anybody knows how to to that???

Tks in advance.

Paulo

 

[gemma-the-husky]

design a query. in the criteria

under
initial zip code, put >=specific zip code.

under
final zip code, put <=specific zip code.

put area in another output column.

this will return areas of all possible zip codes.

assumes final codes are always greater than initial codes, and no codes are null. also assumes you know the specific zip code. you may need to code this with a function call

 

[paulogeneroso]

Hi gemma-the-husky!!!
I'm almost there. Could you please, be a little more specific.
Sorry guy, but I tried but I didn't get what I need. When I put in the criteria ">=[specific ZIP CODE]", I found every initial ZIP code which are greater then the "specific". Till this ok. But when i put "<=[Specific ZIP CODE]" under the final ones I got a problem. It shows me only the "specific ZIP CODE", that is greater then the "Initial..." and less then "Finals..." at the same time.

Could you please help me again??

Tks in advance.

Paulo