View Single Post
Old 05-12-2016, 01:28 PM   #1
Newly Registered User
Join Date: May 2016
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
SlinkyBA is on a distinguished road
County Tables Cross Tab Query

I am using Access 2013 and cannot get this to work.
I have a table that contains a column titled County.
Each field in the County column contains a single county name.
I have two other tables with a column titled County, but these
may have more than one county in the field.

I want to link the lines from the first table using the county name
column from the first table if the same county name is included in
the County column field from the other tables. Even if the field
contains one or more other county names.

My end goal is a form which combines all my data for
each county.

SlinkyBA is offline   Reply With Quote