Date Filter Being Odd, ms access 03, Any Advise?

[Xantara]

I am doing a date range filter, very basic, in MS Access 03. I've done this in VB through code, I've done SQL code, and i've done basic query in Access....

This is my problem...
Date range filter, when making, you make date pulled greater than or equal to first date and lesser than or equal to last date.
My filter is pulling the greater than or equal to first date just fine, however, it's pulling lesser than on last date, and not the equal to part. I tried removing the filter for the end and it pulls from first date forward, so it's seeing the last part, but only the lesser than part, not the greater than part. The following is everything i've tried and it all works the same, i need some fresh eyes, what am i doing wrong, or is there someplace else that i need to look?

This one done in a query:
>=[forms]![Test]![First] And <=[forms]![Test]![End]
under the field mfgdate...does same thing-up to last date, but doesn't include last date

this one done in report filter field:
((mfgdate >= [forms]![Date Time Filter]![DateFirst]) AND (mfgdate<=[forms]![Date Time Filter]![DateLast]))
same thing, up to last date, doesn't inlude it

i've used different forms and reports, thinking i corrupted something, but it all works out the same

what am i missing?

Thank you in advance for saving my sanity!

[Xantara]

nevermind....i fixed it...

instead of fighting with the code, i just took the date from the filter form, added 1 to it, and it's all good!

DON'T WORK HARDER, WORK SMARTER!!
thanks though...