This is probably something simple, just want a second look. I have a db with a field "Datetobecompleted". I am trying to run a simple query that will display results for today and today +3. I have put todays date and went up to the 14th and still no luck. The query I am using is below. I want to add that I use this query on another db and it works just fine. I do not understand why it isnt working on this. Any help would be more than greatly appreciated.
WHERE (((tbljobstodo.[DateToBeCompleted]) Between Date() And Date()+3));