T
Trial & Error
Trying to run a search where a user can enter a date, and have the query
return any records containing that date that have 1 specific field with a
null value.
If I enter Is Null in the criteria under the "Request" field, my query will
return the records I am looking for. However, I do not want ALL the records
from now till the end of eternity... I would like to specify what date
So I enter [Enter Date: dd-mmm-yy] in the criteria under the date field.
I type a date that I know has records with Null values in the Request field,
and no records are returned by the query.
Really bizar.......
any thoughts???
thanks
return any records containing that date that have 1 specific field with a
null value.
If I enter Is Null in the criteria under the "Request" field, my query will
return the records I am looking for. However, I do not want ALL the records
from now till the end of eternity... I would like to specify what date
So I enter [Enter Date: dd-mmm-yy] in the criteria under the date field.
I type a date that I know has records with Null values in the Request field,
and no records are returned by the query.
Really bizar.......
any thoughts???
thanks