DatePart Help Quarter AND Year

[anoble1]

I am making an Access report that will show the quarter of something took place and the year it took place based on the date.

Right now i have it to where it just shows the quarter. I can't figure out how to show the year and quarter.

Here is what I have...

Expr1: DatePart("q",[MeetingDate])

So, it just throws the quarter out there and I have multiple years. Can someone show me how to throw year in there as well?

Thanks

[ADezii]

I am making an Access report that will show the quarter of something took place and the year it took place based on the date.

Right now i have it to where it just shows the quarter. I can't figure out how to show the year and quarter.

Here is what I have...

Expr1: DatePart("q",[MeetingDate])

So, it just throws the quarter out there and I have multiple years. Can someone show me how to throw year in there as well?

Thanks

Year_and_Quarter: Format([MeetingDate],"yyyy") & " - " & DatePart("q",[MeetingDate])

[NeoPa]

Or more simply :

Year_and_Quarter: Format([MeetingDate],'yyyy - q')

[ADezii]

Or more simply :

Year_and_Quarter: Format([MeetingDate],'yyyy - q')

Definitely more simple! (LOL)

[anoble1]

Thanks as always NeoPa, and ADezii.
It works great!

[NeoPa]

I know I can speak for ADezii on this one...

It's a pleasure to help :)