Multi criteria selection / filter

[Schmidtnikov]

Any help is very much appreciated.

I have a table with 543 records, and I need to scale down to 267 via a query
to then update an existing table with the correct Sales Manager and mailing
address..Here are some details

- Each record represents a Sales Manager at a given store, there are 267
total stores...but some stores have more than one Sales Manager (different
title/level) so there are 543 total Sales Managers. I need to get identify
the correct Sales Manager based on the following criteria.

- If GSM, then I want to select that record
- If no GSM, then select PSM
- If no GSM or PSM, them SSM
- If no GSM, PSM, or SSM, then default to General Manager (which I would
have to pull from another table).

Hope that makes sense....thanks for the help.

 

[KARL DEWEY]

Post your table structure with field names and datatype. Post sample data.