In the criteria section of the query under the "DueDate" field, I have entered:
Between Date() And DateAdd("d",5,Date())
to return records that have a due date between today and 5 days from today.
Problem: When I run the query I get no records returned, and I specifically set up two records that would meet the criterion. Can anyone see a problem in my syntax? When I run the query without the criterion, all the records are returned, with the correct DueDate, so I know the DueDate calculation is working. The criterion is such a simple statement, and I can't figure out what's wrong. Please help?