Filter Query Based on two Date Fields

[kobiashi]

hi all


im trying to filter a query based on two fields, these two fields are date fields, [DateComp] and [DateCreated]

what i would like to do is return all entries when [DateComp] is empty and todays date from [DateCreated]

ive tried to add "IsNull" to the [DateComp] critieria, which returns the entried ok, but when i then add "Date()" to the [DateCreated] it then only displays todays date, irrelevant of the filter on [DateComp].

 

[kobiashi]

ive done it, should of tried a little harder

 

[The_Doc_Man]

Congrats on finding your solution. Sometimes all it takes is to step away and smell the flowers for a while so you can clear your head. When I am having trouble with my fiction-writing hobby, that strategy also works.