Software: Office Access XP/2002
Heres the issue: I want to make one query that will do three things with one single criterion.
I have a table named membership running under a form named membership with fields; hisfirstname herfirstname lastname marragedate yearsofmarriage (a calculated field) hisbirthdate hisage (a calculated field) herbirthdate herage (a calculated field). Of course there are many other fields but the above is the basis of the query. The type of fields are names = text, dates = time/date, and ages = number. Now, lets say I have 300 records with the above info. capturing correctly and I want the Query to find ALL his birthdays in December and ALL her birthdays in December and ALL anniversaries in December in ONE Query.
I can accomplish this using one query for each item, etc his birthday which gives me 36
Queries and 36 reports.
I want ONE query to generate a report something like this:
His and Her Name Anniversary Years of Marriage His Name
Their Names mmmm dd calc Name
His Birthday His Age Her Name Her Birthday Her Age
mmmm dd calc Name mmmm dd calc
The query would call multiple fields with one thing in common, a month i.e. December.