Combine Records from Multiple Tables or Queries Together Using a Union Query in Microsoft Access

In this video, I'm going to show you how to use a Union Query to combine the results from two tables with similar fields, such as customers and employees, into one dataset.

Sara from Bar Harbor, Maine (a Platinum Member) asks: I've got a table for customers and a separate table for employees. Is there any way to join them together in a single query so that I can generate reports like mailing labels in one shot. Right now I have to do everything twice and have two separate reports for everything.

Silver Members and up get access to an Extended Cut of this video. Members will see how to easily edit the records in a Union Query. The results from a Union Query are not updateable, but I will show you how to create a listbox and then edit the selected record with either a popup form or a subform.

MEMBERS VIDEO:
https://youtu.be/wvXa78QCnOI

BECOME A MEMBER:
YouTube: https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: https://599cd.com/THMember

LEARN MORE:
https://599cd.com/Union

LINKS:
SQL Basics: https://599cd.com/SQLBasics
Access Expert 16: https://599cd.com/ACX16
Access SQL Seminar: https://599cd.com/SQL1
Microsoft's UNION Query Article: https://tinyurl.com/yhvv9hm3
Intro to VBA: https://599cd.com/IntroVBA
AfterUpdate Event: https://599cd.com/AfterUpdate
On Double Click Event: https://599cd.com/OnDblClick

COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/

KEYWORDS:
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, union query, what is a union query, how do you create a union query, union operation, union queries ms access, union queries in ms access, how to use union queries, combined results, edit union query data, not updateable, union query sort, combine two tables with same fields, edit data in union query, join

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

Видео Combine Records from Multiple Tables or Queries Together Using a Union Query in Microsoft Access канала Computer Learning Zone