if("statement";[result 1];[result 2]), what you seem to be trying is an if statement in an if statement, which is a legitimate thing to do, you just have to set it up a bit differently: If(Base Pay> Commission; Base Pay;(if(commission>Base Pay;Commissiion))) hope that helps. It's basically saying "if this first statement is true, report base pay. If the first statement is false, go to result two (which is an if statement so it checks the opposite, and will report that value)"
ok, first i have 50 fields called DBA 01 - 50.
Not the best database design. Consider a related table of records instead where one record represents DBA 01, a second record is used for DBA 02, etc. This gives you a much more flexible design for your database.
With regards to your If calculation, Chad Mangum is on the right track but we can simplify it to:
If(Base Pay> Commission; Base Pay ; Commission )
You can also use the Max function: Max ( Base Pay ; Commission )