How to put birthdays, anniversaries, divorced and deceased date report

[BrianLundell]

I have a contacts management database where I have added four date fields to the main table labled: Birthday, Anniversary, Divorced, and Deceased. I would like to print out a report that only has three headers: Name, Event (includes whichever of the above four choices, as appropriate), and Date.

Desired format: (Sorted by month and day, but not by year)

Name	Event	Date
George	Birthday	1/14/2002
Nancy	Anniversary	2/3/1998
Tim	Deceased	3/5/2013
Bob	Divorced	5/31/2006

Suggestions?

[BrianLundell]

Solution found. Thanks for reading. It was a fairly simple UNION query, and someone created it for me. I'll post it here in case anyone needs to see the answer in the future.

<code>
SELECT Contacts.ContactName, "Birthday" AS Event, Format([Birthday],"mmdd") AS EventSort, Format([Birthday],"mm/dd/yyyy") AS EventDate
FROM Contacts
WHERE Contacts.Deceased is null and Contacts.Birthday is not null
UNION
SELECT Contacts.ContactName, "Anniversary" AS Event, Format([Anniversary],"mmdd") AS EventSort, Format([Anniversary],"mm/dd/yyyy") AS EventDate
FROM Contacts
WHERE Contacts.Deceased Is Null and Contacts.Divorced is null and Contacts.Anniversary is not null
UNION
SELECT Contacts.ContactName, "Divorced" AS Event, Format([Divorced],"mmdd") AS EventSort,Format([Divorced],"mm/dd/yyyy") AS EventDate
FROM Contacts
WHERE Contacts.Deceased Is Null and Contacts.Divorced is not null
UNION
SELECT Contacts.ContactName, "Deceased" AS Event, Format([Deceased],"mmdd") AS EventSort,Format([Deceased],"mm/dd/yyyy") AS EventDate
FROM Contacts
WHERE Contacts.Deceased Is not Null
ORDER BY EventSort;
</code>