Extracting date from dat/time field : help required

[skinnybloke]

Hi - I have a date field in a Access database in the format
YYYY/MM/DD HH:MM

I have set up 2 date parameters as below but only want to enter the
date and not the time. If I do not enter the time no records are
returned.
SELECT * FROM tables WHERE Order.[Date Received] Between [Enter Start
Date] And [Enter End Date];

Is there a simple way of doing this?

[Allen Browne]

Ask for less than the next day:

SELECT * FROM tables
WHERE (Order.[Date Received] >= [Enter Start Date])
AND (Order.[Date Received] < [Enter End Date] + 1);

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"skinnybloke" <th**************@yahoo.co.uk> wrote in message
news:35********************************@4ax.com...

Hi - I have a date field in a Access database in the format
YYYY/MM/DD HH:MM

I have set up 2 date parameters as below but only want to enter the
date and not the time. If I do not enter the time no records are
returned.
SELECT * FROM tables WHERE Order.[Date Received] Between [Enter Start
Date] And [Enter End Date];

Is there a simple way of doing this?