Query between dates issue (inclusive)

[AccessQuestion]

I am at my wits end. Why is this not simple? So I am trying to query records that fall between two dates, but the ending date is not showing up. So, if I want to see if there is data for today my stopping date has to be tomorrow. Here is my SQL:

SELECT Tasks.[Start Date], Tasks.[Parts Used]
FROM Tasks
WHERE (((Tasks.[Start Date]) Between Forms![Parts Used Report]![Start Date] And Forms![Parts Used Report]![End Date])) And ((Tasks.[Parts Used]) Is Not Null);
 

I have tried to add a +1 to the end date, to no avail. I have Googled my butt off and haven't found anything to help. Anything you can help me with on this would be GREATLY appreciated. Thanks in advance.

*edit*
I have also tried doing a >= and <= and I keep getting an error with the <=. Thanks again.

[gnawoncents]

You were very close. Try this:

 
SELECT Tasks.[Start Date], Tasks.[Parts Used]
FROM Tasks
WHERE (((Tasks.[Start Date])>=[Forms]![Parts Used Report]![Start Date] And (Tasks.[Start Date])<[Forms]![Parts Used Report]![End Date]+1) AND ((Tasks.[Parts Used]) Is Not Null));
 

[OldBirdman]

If the start and end dates in the table contain a time component, then any time after midnight 0:00:00 will be greater than the date without a time entered in the textbox of the form, and therefore fail the BETWEEN ... AND ... test.
Unless the DATEADD() function is used to add 1 day, that logic will fail also.
Also, the WHERE clause needs to explicitly state that the text be treated as a date, so the final result should look like:

WHERE (Tasks.[Start Date] Between #4/1/2010# And #6/30/2010# and ....

This is usually done in VBA by building an SQL string, and then running the query

[AccessQuestion]

@gnawoncents
Thank you so much gnawoncents!! The old position of the +1 mistake. It's working perfectly. Thanks again.

[gnawoncents]

Glad to hear it's working for you!