default date 1

[shart00]

The query is set to pull all areas despit if they have data or not ( this is so that those who download the info into excel do not need to constantly change ranges in the linked files).

The problem is that if there is no data for an area, the field [Reportdate] appears null. This is not necessarily a problem for those who download, but for those who want the access report the missing of the date messes with the report title.

Is there away to tell the query if [ReportDate] is null then use the max([reportdate]) or something so that if it is missing it will be filled in with the default date which needs to be whatever day is currently in the field [reportdate]?????

 

[PHV]

I'm not sure to have well understood the issue.
Perhaps something like this (in query grid) ?
ReportDate: Nz([ReportDate], Date())

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244