Week Nos with Year Tag in Access

[sanket]

Hi,

I just want to know whether it is possible to have week nos with year tag in MS Access.

Example - currently if we want to know week no of date - 14/05/2015 answer is 20 but i want it in 1520 format in which 15 represent year tag.

Pls help me in solving this issue.

Thanks & Regards,
Sanket

 

[Joe4]

Try:

Format([DateField],"yy") & DatePart("ww",[DateField])