Access 2013 - need to convert date to quarter and year in the same column

I am using access 2013 and I have a date column (12/26/2014) and I want to run a query where I make another column that will show as the fourth quarter of 2014.

I am currently using:

 Quarter: DatePart("q",[created time])

But I need it show the year on it as well and I am not sure how to add that.

I am not too concerned how it is formatted as long as I can see that it is the 4th quarter of a particular year.

Maybe something like:

4:2014
or 4/2014
or 4,2014

Thanks,
Richard
rnhturner1Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
Quarter: DatePart("q",[created time]) &"/" & year([created time])
0
 
Rey Obrero (Capricorn1)Commented:
just change  &"/" & to whatever format you want.
0
All Courses

From novice to tech pro — start learning today.