1) I need to build a query that will look for dates in a date field that are >= 4 1/2 years from a date specified by the user. For example, if the user enters Sep 2011 the query would return all records in the database that are 4 1/2 years older than the specified date (i.e. Mar 2007). There is another date field if the record meets the query criteria but the 2nd date field is populated then the record will not be returned.
2) How do I format the input request from the user to ensure Access understands what to compare with the Inv_Date field?
The query results would be in a new colum title Investigation Due.
Software/Hardware used: MS Access 2007, Windows Vista Enterprise