If statement in form field

[Gabriel2012]

Hello, I have a form were the "Date of error" is entered as well as the "Period" (accounting period). Is there a way to enter an If statement into the period field so that the period will change dependant on the date that is entered in the "Date of error" field? I.E 02/02/2013 is the date of error so "2" is populated in the Period field.



Thank you for any help.

[June7]

That would require code to save the calculated value. However, why bother? Saving calculated data is usually a bad idea. The value can be calculated in query or on form/report when needed.

What is basis for 'period' - quarterly starting with January?

Format([Date of error], "q")

BTW, advise no spaces or special characters/punctuation (underscore is exception) in names nor reserved words as names. If used, must enclose in [].