Listing birthdays - best method?

A

Aaron G

Hi all,

Access 2003 - I'm trying to get a list of birthdays grouped by month. My db
has "Clients" and "Spouses". I create a query for each of them filtering out
null birthdays and making a simple expression to show the month. I now want
these combined so I can get a report that shows both "Client" and "Spouse"
birtdays grouped by month.

What's the best way to do this?

TIA

Aaron G
Philadelphia, PA
 
R

Rick B

You should build a UNION query instead to pull in both in one query. Make
sure to sort on month, then day.
 
A

Aaron G

Thanks Rick. I haven't used UNION before, but a quick lookup to the help
section gave me a great example. Thanks!

Aaron G
Philadelphia, PA
 
Top