Hello All,
First off I don't know if "backdating" is the correct term for this issue, but I'm unsure of what else to call it.
I have a form that has two fields (we'll call them A & B) that provide parameters for a query, both of which are formatted as General Dates. They are used to select an interval of dates to find which contracts end between those two dates.
The query works perfectly at the moment and returns the data that it should, but there is a minor loophole I would like to close up before launching the database company wide - if the user selects a second date(field B) that happens to be before the first date(field A) results still come back...
Is there any way to have an error message appear if the user selects a date in Field B that occurs before Field A? I would imagine there is but due to my amateur Access knowledge I can't seem to figure it out.
Any help would be greatly appreciated! Thanks!