I want to create a calculated field in my query,by finding the greater of 2 other fields (in the same table).
I am having some trouble getting the syntax right.
Anyone got a simple answer pls.

In a new column: Calc:IIF([Field1]>[Field2],[Field1],[Field2])

For more information on the IIF statement search Access Help.

Jack:
Great stuff.Works perfectly
Many thanks.
Ps I do read the help files extensively but sometimes u just get lost...or suffer a mental block on a prob. http://www.access-programmers.co.uk/ubb/smile.gif