Hi,
I have a form that displays the date of any records that I would like to see for a specific date in a query, however the timestamp that I am using has the time. How can I find all records in my query for the date that I am looking for?
I'm trying the following but it is not working:
I have tried various things, but I thought that the code above would work for me but it doesn't. The field that I am using on the form to input the date is TheDate.
Many thanks,
Malcolm
I have a form that displays the date of any records that I would like to see for a specific date in a query, however the timestamp that I am using has the time. How can I find all records in my query for the date that I am looking for?
I'm trying the following but it is not working:
Code:
>=[Forms]![FirstLoad]![TheDate 00:00:01] And <=[Forms]![FirstLoad]![TheDate 23:59:99]
I have tried various things, but I thought that the code above would work for me but it doesn't. The field that I am using on the form to input the date is TheDate.
Many thanks,
Malcolm