[AccessD] Pull Most Recent

Gustav Brock gustav at cactus.dk
Tue Sep 30 11:17:41 CDT 2003


Hi Gowey

No reason to write code.
Just use this (replace 1 to 6 with your field names):

=IIf(6>IIf(5>IIf(4>IIf(3>IIf(2>1;2;1);3;IIf(2>1;2;1));4;IIf(3>IIf(2>1;2;1);3;IIf(2>1;2;1)));5;IIf(4>IIf(3>IIf(2>1;2;1);3;IIf(2>1;2;1));4;IIf(3>IIf(2>1;2;1);3;IIf(2>1;2;1))));6;IIf(5>IIf(4>IIf(3>IIf(2>1;2;1);3;IIf(2>1;2;1));4;IIf(3>IIf(2>1;2;1);3;IIf(2>1;2;1)));5;IIf(4>IIf(3>IIf(2>1;2;1);3;IIf(2>1;2;1));4;IIf(3>IIf(2>1;2;1);3;IIf(2>1;2;1)))))

Watch for line wrap!

/gustav

PS: Isn't it Friday yet?

>         I have 6 fields within my table that have dates in them, how can
> I pull and display on a form which field has the most recent date in it?



More information about the AccessD mailing list