In order to perform conflict searches in my Access 2007 database, you enter a bunch of information and then receive a report of cases with similar information in order to avoid any conflicts of interest.
One of the fields is "Date of Accident". Currently I have its format set as yyyy/mm/dd. However, my expression
returns nothing (if I look at the query in Datasheet the column is blank).
I found a fix for getting it to appear by removing the format on Date of Accident, however, my query doesn't retrieve cases with matching dates (the dates are formatted to dddd, mmmm dd, yyyy as a Date/Time Data Type).
Is there any way I can get the query to both return the date searched, AND retrieve matching cases?
Thanks!
One of the fields is "Date of Accident". Currently I have its format set as yyyy/mm/dd. However, my expression
Code:
Date Searched: [Forms]![frmConflictSearch]![Date of Accident]
I found a fix for getting it to appear by removing the format on Date of Accident, however, my query doesn't retrieve cases with matching dates (the dates are formatted to dddd, mmmm dd, yyyy as a Date/Time Data Type).
Is there any way I can get the query to both return the date searched, AND retrieve matching cases?
Thanks!