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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a user controlled filter - best methods 2
Tab Control - best loading method 3
Linking forms to tables 3
Removing (and then getting back) toolbars 2
Grouping on a form... possible? 2
Professional app deployment - best practices 3
When to Create Separate Tables? 6
Identifying a popup's "root" form 4

Top