max value in an access record

[JustATheory]

Greetings,

I'm trying to write an Access query function that will give me the max value within three fields of a record. It is similar to =max() in excel. I'm only finding documentation for max values within a field. Any help would be greatly appreciated.

Thanks,
Andy

 

[fredericofonseca]

http://allenbrowne.com/func-09.html

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com