Go Back   Access World Forums > Microsoft Access Discussion > Queries

Thread Tools Rate Thread Display Modes
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
Old 05-12-2016, 02:57 PM   #2
Newly Registered User
Join Date: Apr 2015
Location: KY,USA
Posts: 3,400
Thanks: 0
Thanked 753 Times in 736 Posts
Ranman256 will become famous soon enough Ranman256 will become famous soon enough
Re: County Tables Cross Tab Query

Ok, build Q1 that joins the 2 tables and pulls the data you want.
Then build Q2, that pulls Q1 data into a Crosstab.
Ranman256 is offline   Reply With Quote

cross tab query , forms , reports , table

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Cross Tab Query - Cross Wired NauticalGent Queries 3 03-18-2016 09:21 AM
I need to get the Top 10 per State and County bconner Queries 7 02-27-2015 09:44 AM
Cross join to create ledger type query from 4 tables Ramnik General 7 04-05-2013 04:17 AM
Cross Reference Tables Nevsky78 Tables 6 12-21-2010 06:15 AM
Cross-referencing two tables on a form Courtman Tables 1 08-09-2002 06:30 PM

All times are GMT -8. The time now is 02:57 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World