Two Queries in One Report

[MeghanK]

Hi there,

I am building a registration database for an event. Basically, each form has
the attendee name and spouse guest name, within this form, there is an option
to choose from a drop down menu (from a table) their recreation choice, one
for the attendee and one for the spouse guest.

I have built two separate Queries from this, I have one that shows only
Attendees who picked "Golf" (for example) and one that has only Guests who
picked "Golf". What I want to do is have one report that I can open that will
show the results of the two queries without showing for example if an
attendee picked Golf the Spouse Guest name if they did not pick it (the
reason for the two queries). I am not a wizard at access, I saw something
about Union Queries but no clue how to create one?

Hopefully this makes sense? Any help would be GREATLY appreciated!

Thanks!

MK

 

[KC-Mass]

Hi, Meghan

What is the structure of the two original tables and on what field are they
related.

It should be a simple query from those tables. I would forget the two
queries written for
another purpose.

You may also want to reread what you sent.

Regards

Kevin