All,
I have a query that is returning #error instead of a null value for a calculated date field. I'm using the dateserial() function to transform the individual dates to the first date of the month. (e.g. dateserial(year([posting date]), month([posting date]),1)) In another query I'm using that field to join and return a value, which returns as #error. I've tried nz(), isnull(), and isempty() for the error handling, but I still get #error. I also tried the cdate() function to ensure the field is recognized as a date, but I still get #error. Any thoughts of what I could do differently to remove the #error?
I have a query that is returning #error instead of a null value for a calculated date field. I'm using the dateserial() function to transform the individual dates to the first date of the month. (e.g. dateserial(year([posting date]), month([posting date]),1)) In another query I'm using that field to join and return a value, which returns as #error. I've tried nz(), isnull(), and isempty() for the error handling, but I still get #error. I also tried the cdate() function to ensure the field is recognized as a date, but I still get #error. Any thoughts of what I could do differently to remove the #error?
