Display birthday for client and client's spouse

[dougdrex]

I'm using Access 2010 to build a database to track clients and assist with follow up.



One of the queries I'd like to build is a monthly birthday report. My challenge is that I have a table tbl_Clients with fields FirstName, MiddleName, LastName, and BirthDate. I also have fields SpouseFirstName, SpouseLastName, and SpouseBirthDate.

Querying the clients with a birthday in a given month is quite simple. What I'm struggling with is including the spouse information in the report. I'd like to list the spouse if their birthday is in the month without listing the client information (if their birthday is NOT in that month). Is this possible?

I can attach a zipped file of the database if it would be helpful.

Thanks!
Doug

[ranman256]

No, it is not attached, but
Q1 =query your clients with bday that month
Q2 = Q1 and join to tClients.spouse

[dougdrex]

To make sure I understand, you're saying I should create two different queries (one for the clients with bdays in a specific month, and another for the spouses with bdays in a specific month), then join them?

[dougdrex]

Based upon reading another thread on this forum on the topic, I created a report for both of my queries. Then I "dragged and dropped" one of them into the other. I've got everything working fine except that there is a prompt in each query for the month number, so when I run the report, it prompts twice for the month number. How can I fix it so that it only prompts for the month number once?