Greetings,
I have a field on a form (ReviewStamp) that is timestamped Date() if Completed is selected in a combo box. However when I try to query for records using this field in the table, I get no results. I've tried creating a query using Date() for the criteria under the ReviewStamp field and tried using a date range query but to no avail. Does the time have anything to do with the query not working? Help. Thanks.
I have a field on a form (ReviewStamp) that is timestamped Date() if Completed is selected in a combo box. However when I try to query for records using this field in the table, I get no results. I've tried creating a query using Date() for the criteria under the ReviewStamp field and tried using a date range query but to no avail. Does the time have anything to do with the query not working? Help. Thanks.