IF statement

[COMP]

hey guys, im trying to create an IF statement. I want the if statement to say if a certain field is either jan,feb,march,april then make another field say Quarter 1. If the certain field says may june july aug then quater 2. Im trying to create this in access but am not having any luck. Any ideas??

thanks

 

[Scooterbug]

Dont really need that...you can simply format the date in question to reflect the quarter:

Quarter: "Quarter " & format([YourDateHere],"q")

 

[statsman]

That's a good one Scooter.
I didn't know there was a Quarter function.

 

[Scooterbug]

Normally, I despise help files...but I usually go to the VBA Editor Help file before going anywhere else to check things out. You can do quite a bit of date/time formatting