I have searched for the answer to this but just can't seem to figure it out. I am trying to do a query using BETWEEN/AND on a date field that contains time. When the user clicks a button, they are asked to put in the start date and end date. So for example if the user wanted records between the dates of 9/25/2010 and 9/30/2010 the records from 9/30/2010 do not return. I know this is a factor of the time and that Access views the date of 9/30/2010 at the time of 00:00:00 so technically the query runs correct since all dates do fall between 9/25/2010 00:00:00 and 9/30/2010 00:00:00. I assume I have to add one day to the day input by the user but can't figure out the syntax. Anybody know how to do this? Thanks.
Code:
SELECT tblQuestions.*, tblQuestions.LastUpdated
FROM tblQuestions INNER JOIN tblTempUniqueQuestIDchanges ON tblQuestions.QuestID = tblTempUniqueQuestIDchanges.QuestID
WHERE (((tblQuestions.LastUpdated) Between [Enter start date] And [Enter thru date]));