Go Back   Access World Forums > Microsoft Access Discussion > Queries

Thread Tools Rate Thread Display Modes
Old 03-16-2019, 06:25 AM   #1
Newly Registered User
Join Date: Jul 2007
Posts: 384
Thanks: 132
Thanked 1 Time in 1 Post
sumdumgai is on a distinguished road
how to use a Union query to get distinct records

I have three identically designed tables. I do not want to combine rows with a Union or Union All. What is the query that would give me the distinct pairings of field1 and field2 for all three tables?

Thanks for your help.

sumdumgai is offline   Reply With Quote
Old 03-16-2019, 08:42 AM   #2
Newly Registered User
June7's Avatar
Join Date: Mar 2014
Posts: 1,395
Thanks: 0
Thanked 340 Times in 339 Posts
June7 will become famous soon enough
Re: how to use a Union query to get distinct records

Sorry, use UNION.
To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
The Following User Says Thank You to June7 For This Useful Post:
sumdumgai (03-17-2019)

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Union Query seems to have too few records David Ball Queries 4 01-26-2016 05:57 AM
[SOLVED] A query with Distinct against a SQL view with Distinct truncates string Rx_ SQL Server 2 05-05-2015 08:13 AM
250 million records in a union query Access9001 General 16 08-28-2011 05:06 PM
Help! Query to show distinct price records hardrock Queries 3 03-04-2009 07:41 AM
need distinct records of whle table but distinct on one field ukdata Queries 1 09-16-2006 11:22 PM

All times are GMT -8. The time now is 12:36 PM.

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 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World