I have purchased several of your classes and have learned a great deal. 101-329 ETC....

My question is in regards to a Query.
I'm running a Query between dates. 12/11/12 - 12/25/12
It is excluding the 25th, I know that you want over this but I'm not sure what lesson. I remember that it looks at the dates as 12:00 midnight and my data is after 8 am on the 25th. I'm unable to remember how to have it include all of the 25th.
Can you point me to the lesson or help me out with this.

Thank you

Perry

---

You have to say:

>=[StartDate] AND <[EndDate]+1

So if your dates are 1/1 and 3/1 you would say:

>=#1/1/2012# AND <#3/2/2012#

I cover this in Access 5 or see THIS tip.