Access wouldn't run my query because of "undefined function 'Maximum' in expression". The field associated with the error message is as follows. Can someone tell me what's wrong with my field definition? Many thanks!
Field Name: IIf([Field A]<>"0",Val([Field B]),Maximum([Field C],[Field D]))
Field Name: IIf([Field A]<>"0",Val([Field B]),Maximum([Field C],[Field D]))