I am using a form to enter a date range which is being used by several queries in a macro.The query has - WHERE (((dbo_LDEdala_ApplicationConsent.DecisionIssuedDa te) Between [forms]![Decisions - Enter_Dates].[BeginningDate] And [forms]![Decisions - Enter_Dates].[EndingDate])
The problem is that if I enter 25/7/2010 in the BeginningDate and 28/7/2010 in the EndingDate, I only get records for th 25/7, 26/7 and 27/7, not for the 28/7. My work around is to enter 28/7/2010 11:59:59PM into the EndingDate - then I get the reords for the 28/7 also. I don't want the users to have to enter "11:59:59PM" - what is the answer please?
Thanks
Steve