Filtering Question

[Zane]

I am trying to filter my database based on two dates.
Currently I have it to where it will filter based on a
month the user inputs. This takes looks at both dates in
the record and if either is in the month that the user is
looking for than the record will be displayed. The sql
statement looks like:

FROM [MAIN TABLE]
WHERE (((Format([Modified Disclosure Date],"mmmm"))=
[Select]![Month]) OR ((Format([Disclosure Date],"mmmm"))=
[Select]![Month2]))

What I want it to do is to filter the modified disclosure
date first, than if the record hasn't been modified
filter based on the original disclosure date. Any help
would be greatly appreciated.

Zane

 

[John Spencer (MVP)]

FROM [MAIN TABLE]
WHERE Format([Modified Disclosure Date],"mmmm")= [Select]![Month] OR
([Modified Disclosure Date] is Null AND
Format([Disclosure Date],"mmmm")=[Select]![Month2])