Iff to calculate # of weeks, convert Excel

[pete234]

I have a formula that works fine in Excel but can't seem to recreate in Access.

=IF(OR([@[Period]=3,[@[Period]]=6,[@[Period]]=9,[@[Period]]=12)=[Budget_Amount]/5,[Budget_Amount]/4)

this is what is in my Excel table, I just need weeks for custom fiscal table to make another calculation in a query.

 

[alansidman]

=IIF(Period = 3 or Period = 6 or Period = 9 or Period = 12, [Budget_Amount]/5, [Budget_Amount]/4)

Try the above.

Alan