Please Help!
I have several different tables with date fields for different things, i.e ID expiry, Course Expiry, Passport Expiry, etc. These fields are stored in different tables. E.g:
Table 1 Table 2 Table 3
text field date field text field
text field text field date field
date field text field text field
I want to run a query that prompts the user to enter an expiry date (mm/yy) and produce a stepped report of the person's name and details of all date fields across all tables that expire in the month and year input by the user.
I think I just need a bit of code that brings all these date fields together so I can query it, prompting the user to enter a date but I have no idea how to do it.
Please help as I am about to :banghead:.
Thanks in advance
shosim85
I have several different tables with date fields for different things, i.e ID expiry, Course Expiry, Passport Expiry, etc. These fields are stored in different tables. E.g:
Table 1 Table 2 Table 3
text field date field text field
text field text field date field
date field text field text field
I want to run a query that prompts the user to enter an expiry date (mm/yy) and produce a stepped report of the person's name and details of all date fields across all tables that expire in the month and year input by the user.
I think I just need a bit of code that brings all these date fields together so I can query it, prompting the user to enter a date but I have no idea how to do it.
Please help as I am about to :banghead:.
Thanks in advance
shosim85