Switch function

[Lmens]

Hello

Can someone help me with this Switch()? The query runs but the result is not right.
I want to group a date column (2009) into quarters. Below is one for quarter 3 for April, May June. The date column (2009) has m/d/yyyy format


2009_Q2: Switch(Month([TimeWriting].[2009])=4 Or 5 Or 6,[TimeWriting].[2009])

Any help given is much appreciated. Thank you.

 

[pbaldy]

More along the lines of:

2009_Q2: Switch(Month([TimeWriting].[2009]) IN(4,5,6),[TimeWriting].[2009])

 

[Lmens]

Perfect! Thanks.

 

[pbaldy]

No problemo!