If Statments in Access

[Guest]

Hi,
I have two fields in a query wit different numbers, i am trying to pick the
greater number from the fields and subtract it from the third one to get a
precentage for YTD. This is wat i have
([+/- YTD]*100)/(iff(([2005 YTD]<[2006 YTD]),[2005 YTD],[2006 YTD]))

Thnks

 

[Duane Hookom]

"subtract if from the third one"? You can use IIf() rather than Iff().