Multi field of date filter

[Frank Situmorang]

Hello,

Previously below string is connected by AND, how if I changed them to OR,
because what I want is any date field which have the same range date taken
from form filter will be shown in the report. Will it work?

'Build filter string
strFilter = "[Dateof Birth] " & strDOB & _
" OR [DateofBaptized] " & strDtBaptized & _
" OR Dateof Marriage] " & DateofMarriage & _
" OR [DateofDeath] " & strDateofDeath

Thanks for any idea

 

[Douglas J. Steele]

Did you try it? That probably would have been faster than posting and
waiting for an answer...

What's in strDOB, strDtBaptized etc?

 

[Ron2006]

As I look at what you posted, I DON'T see any condition being
specified.

However, in general, if you change the OR to an AND then ALL four of
the conditions would have to be satisfied simultaneously for the
record to be selected.

Ron