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