Search results

I changed it to Docmd.OpenReport myReport,acPreview,,strFilter and work. not sure why?

Add a hidden field = iif(Attended, 1, 0). Then do sum again.

How about use iif() DateAdd("h",iif(yourDate>dateStart and yourDate<dateEnd,-3,-2),[column name])

Hi, When I open a report, I want to use the filter in current Form. Code like: If me.flterOn then strFilter=Me.Filter end if Docmd.OpenReport myReport,acPreview,strFilter The report displays all record regardless my fileter. Any idea? Thanks.