How to create a query (and reports) from data from TWO tables that aren't related?

[southhaven]

Hi. First post. I'm pretty much a novice at Access and hope you can help.

I have an event coming up and my Access file has two tables, one for the event volunteers and one for the event attendees. They each contain mostly different fields such as these (simplified example):

Volunteers table fields
First Name, Last Name, Gender, Class, Phone, Role



Attendees table fields
Name First, Name Last, Phone Number, Address, Role

None of the volunteers exist in the Attendee table and no attendee exists in the Volunteer table. So there is no shared ID or any other field. Note also that the First Name field is named differently in the two tables as is the Last Name field.

However, I want to create a query (and then reports) that include both volunteers and attendees that will display, for example, these fields for BOTH volunteers and attendees:

First Name, Last Name, Phone, Role

So the query's list might look like:

John, Smith, 444-4444, Volunteer
Jane, Doe, 333-3434, Attendee
Sam, Jones, 234-5858, Attendee
Jen, James, 484-4848, Volunteer

How do I create a query that gives me results from BOTH tables? Any help appreciated. Thanks.

Dave

[Beetle]

This is a cross post and an answer has already been provided in the other forum

https://www.access-programmers.co.uk...d.php?t=299274