One of the output fields in my query is Target_Date and to avoid blanks appearing in the report I have used the Nz function as follows:
Target Date: Nz([Target_Date],"No target date agreed")
The results of this query are exported to Excel but it seems that the Nz function is converting the date to a text format so filters and sorts do not work properly.
Is there a way I can amend my query so that excel will recognise the output as a date?
Tim