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].
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].