Min/Max Function

[Littlemalky]

Can you not use the Min/Max functions in Access the same way as Excel? For example, I'm trying to replicate a formula I have in Excel that is structured like this. But it is kicking back saying I have the wrong number of arguments. Can I not use comma separators?

L1_PAYOUT: Max(0,(Min(0.9,[%_TO_QUOTA])-0.7)*(2275/4)*100)*[QTR_COMPLETION]

 

[Joe4]

It is important to understand that Access and Excel are very different beasts by nature; one is not an extension of the other.
Access is a relational database program. Excel is not. Therefore, they do not have all the same functions and commands.

Access does have MAX and MIN functions, but they have a very different meaning. They are aggregate functions. If you have ever used Pivot Tables in Excel, it is more like that.
So, it would be the MAX or MIN of a single FIELD (column), not of two items that you are trying to compare.

For what you are trying to do, you would probably use something like an Immediate If statement (IIF) in Access, which is like and IF statement in Excel.
Similar to Excel, you can nest IIF statements in Access.

 

[Littlemalky]

Thank you Joe

 

[Joe4]

You are welcome.