Excel Formulas in Access

[6two6rob]

So I know that Excel supports basic programming statements like the ever useful IF statement. I was just wondering if anyone knows if it is possible to use these types of statements in Access?

I am aware that access does support Iff statements, but not IF in the query sections of access.

 

[sheetspread]

but not IF in the query sections of access.

If you view the SQL of a query with IIfs you'll see them, or did you mean the filter conditions?

 

[6two6rob]

No I meant that in the Criteria section of a query in access, it allows the use of the Iff statement, but does not understand IF(var,var,var) statements that I'm used to using in Excel.

 

[sheetspread]

The criteria is usually for filtering records, the IIf you're describing works best in a query column (with the expression builder if you like).