Multi field of date filter

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

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
 
Did you try it? That probably would have been faster than posting and
waiting for an answer...

What's in strDOB, strDtBaptized etc?
 
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
 
Back
Top