I have a basic access database that has gone through many iterations over the years (it is probably about 15 - 20 years old). I am constantly upgrading it. The problem I am now facing is that when I originally wrote the database, I made the decision to have different tables containing years, months, and days. It made a lot of sense at the time. Now I want to be able to query the database for the start date and end date for each individual listed in the DB. The problem is I can easily use user entry on a date field but have a more difficult time asking the database to show me everyone who started after date x but before date y if I am not querying a single field.
I use this code to request user input on a date field:
>=[Start Date:] And <=[End Date:]
How would I combine my start year and start month fields, which are currently lookups to the start month and start year tables, into a date field?