Filter by Date

[Guest]

When the date filter is applied in a Form not every row with the same date is
being filtered. I suspect this is due to a hidden time factor. How do you
format the cell so that all records in a column with the same date will be
filtered out when required?

 

[strive4peace]

Hi Pete,

not format... strip the time away -- one way is to use the DateValue
function

me.filter = "DateValue([DateFieldName]) = #" & me.somedate & "#"
me.filteron = true

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*