I have a field that calculates a date range from a record in my query.
Date: Format([TransactionDate],"yyyy") & "-" & Format([transactionDate],"yy")+1
My problem is that if TransactionDate is blank, it returns #ERROR. I am linking this query to Excel, which means I cannot use the NZ() function to return a null value. Is there any way to do this without NZ()?
Date: Format([TransactionDate],"yyyy") & "-" & Format([transactionDate],"yy")+1
My problem is that if TransactionDate is blank, it returns #ERROR. I am linking this query to Excel, which means I cannot use the NZ() function to return a null value. Is there any way to do this without NZ()?