I have a dataset in which i have a variable Bill date like this
Bill Date 1/16/2012 11/16/2012 11/16/2012 11/16/2012 11/16/2012 1/16/2012 1/16/2012 1/16/2012 1/16/2012 1/16/2012 1/16/2012
Now I want to create another variable 'Quarter' and calculate this on the basis of Date and want the output as follow
Quarter Q1-2012 Q4-2012 Q4-2012 Q4-2012 Q4-2012 Q1-2012 Q1-2012 Q1-2012 Q1-2012 Q1-2012 Q1-2012
I was thinking of doing this with the combination of Datepart and if-elseif combinations. But as per my knowledge access donot support multiple Ifs statement and I dont want to write VBA code for the same
Please suggest
Thanks
Dinesh