Date Expression Error

[Guest]

I am using Micrsoft Access 2007 and i get the error when i generate the report.
A pop up message saying "Function is not available in expressions in query
expression 'format(nz(min(TLO_Date),"7/16/2007"),"dd/mm/yyyy"' is displayed.
Proceeding further by clicking OK multiple times, report will be displayed.
But the dates are displayed wrongly in this report.

Can somebody advise on that? Many Thanks.

 

[John W. Vinson]

I am using Micrsoft Access 2007 and i get the error when i generate the report.
A pop up message saying "Function is not available in expressions in query
expression 'format(nz(min(TLO_Date),"7/16/2007"),"dd/mm/yyyy"' is displayed.
Proceeding further by clicking OK multiple times, report will be displayed.
But the dates are displayed wrongly in this report.

Can somebody advise on that? Many Thanks.

For one thing, a date literal should be delimited by # rather than "; for a
second, you don't have a closing parenthesis for the Format function.

I'd suggest just applying a dd/mm/yyyy Format property to the textbox itself,
and set its control source to

=NZ(Min([TLO_Date]), #7/16/2007#)

Not sure about the Min, that's going to depend on the context of the rest of
your query!

John W. Vinson [MVP]