I have tblOrderDetails.SelectionDate field that has a default value of 'Now()'
So my fields include a time stamp along with the date
I have a query with the following:
((tblOrderDetails.SelectionDate) Between [Forms]![frmDateSelection]![Calendar0] And [Forms]![frmDateSelection]![Calendar1]))
The calendar1 value is never included in the query results???
Is this a glitch? If I select 11/30/10 as then calendar1 date
when the statement is evaluated it doesn't include anything that has a time stamp on that date. Does Access assume it has to be before 12:00 am on 11/30/10??
How can I get around this?
So my fields include a time stamp along with the date
I have a query with the following:
((tblOrderDetails.SelectionDate) Between [Forms]![frmDateSelection]![Calendar0] And [Forms]![frmDateSelection]![Calendar1]))
The calendar1 value is never included in the query results???
Is this a glitch? If I select 11/30/10 as then calendar1 date
when the statement is evaluated it doesn't include anything that has a time stamp on that date. Does Access assume it has to be before 12:00 am on 11/30/10??
How can I get around this?