P
Pat Dools
Hello,
I am trying to assign 'Quarter' values based on a month number with the
following formula. It works great for 'Q1' and 'Q2', but does not work
(leaves blanks) when the month number falls within the third ('Q3') or fourth
quarter ('Q4'):
Qt_Qtr:
IIf([Quote_Mnth]<4,"Q1",IIf([Quote_Mnth]>3,IIf([Quote_Mnth]<7,"Q2"),IIf([Quote_Mnth]>6,IIf([Quote_Mnth]<10,"Q3"),"Q4")))
If anyone has easier ways of assigning a 'Quarter' value to a record, I'm
also open to any suggestions!
I am trying to assign 'Quarter' values based on a month number with the
following formula. It works great for 'Q1' and 'Q2', but does not work
(leaves blanks) when the month number falls within the third ('Q3') or fourth
quarter ('Q4'):
Qt_Qtr:
IIf([Quote_Mnth]<4,"Q1",IIf([Quote_Mnth]>3,IIf([Quote_Mnth]<7,"Q2"),IIf([Quote_Mnth]>6,IIf([Quote_Mnth]<10,"Q3"),"Q4")))
If anyone has easier ways of assigning a 'Quarter' value to a record, I'm
also open to any suggestions!