Matching Zip Codes

[pops49]

I am trying to match people according to their zip code. I want to input their names in a form and it would automatically put them in a group with others that match their zip code. Any suggestions would help. Thanks

 

[dhookom]

This doesn't make much sense. Can you tell us about your table structures and what you want? Are the "people" in a table?

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

Hi,

You have not shared very much specific information.

Select People, ZipCode
From [Some Table]
Order by ZipCode

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[pops49]

dhookom,

The names would be in a table. I am trying to match them to a teacher in their area. The teacher names and zip code would also be in a table. Sorry for not being clearer.

 

[dhookom]

Assuming you have a form for teachers, you can add a subform of names and use the ZipCode fields as the Link Master/Child.

If this doesn't work, you need to provide more specific information.

Duane
Hook'D on Access
MS Access MVP

 

[pops49]

Thanks dhookom,

Simple for some, harder for others.