Ignore Time In Date and Time Field

[ir26121973]

Hi,

Wonder if someone can help please. I'm quite new to Access so please bear with me.

I have a data field in my database consisting of both a date and time.

I then have a form containing two fields where the user can type a 'To' and 'From' date to extract the records that they are interested in. The query behind this uses the 'Between[Enter The Date] And [Enter The Date]' coding.

The problem is that because the field contains a time it doesn't return any records when I run the query.

Can anyone offer a bit of guidance on how I could ignore the time part of the field perhaps by adapting the above.

Many thanks

Chris

 

[boblarson]

Create an extra column in your query that is formatted to just date:

DateOnly:Format(YourDateFieldNameHere,"mm/dd/yyyy")

and put the between criteria in the criteria of that column

 

[ir26121973]

That's great Bob, many thanks much appreciated.

Regards

Chris