Alfie2008
01-25-2011, 06:22 AM
Hi,
I have written an iif statement in query design grid as follows;
IIf([tblCustStatusLookup]![stsStatusID]=2,[stsDate],"Cancelled")
I have specified MAX in the design grid Total field
It returns a date but not the correct MAX eg. out of the following dates;
06/11/2010
17/03/2010
I would expect 06/11/2010 but it returns 17/03/2010
It seems to be taking the MAX of the number eg. 17
How do I amend to return the MAX date ?
thanks
Ian
I have written an iif statement in query design grid as follows;
IIf([tblCustStatusLookup]![stsStatusID]=2,[stsDate],"Cancelled")
I have specified MAX in the design grid Total field
It returns a date but not the correct MAX eg. out of the following dates;
06/11/2010
17/03/2010
I would expect 06/11/2010 but it returns 17/03/2010
It seems to be taking the MAX of the number eg. 17
How do I amend to return the MAX date ?
thanks
Ian