Statement

[Gootz11]

Hello,
I have a query with an ID field as well as 35 other colums.
I need to write a statement that by ID will give me the MAX record from this 35 Colums. Please Help

Thank
J

 

[pbaldy]

Sounds like a db crying out for normalization, but this may work for you:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209857