Thanks for the response, I will try to be more clear. My first set of data is
company contact information including their state and county for over 42000
companies in an excel spreadsheet. The second set of data is 240 records
which describe a certain status for a given geographic area. That
spreadsheet contains records which each having its own unique ID number and
each record covering one or more states AND one or more counties in that
state.

I am trying to be able to use the county location from the company records
(first data set) to see if they are in one of the counties included in the
records of the second data set.

Again, hope this is stated better and is a reasonable request. THANKS

Fred wrote:
I noticed that still nobody answered. If I may direct in an attempt to be
helpful.....

Overall, a question like this requires telling us about the nature and
structure of your data. You did this well on the first table, everything
after that was a jumble, hopping all over the place telling us about
ancillary items. Be sure to include telling us what specifically is in that
second table..

Also a clearer statement of what you are trying to do.

Hope that helps a little.

--
Message posted via http://www.accessmonster.com