Hello,
I am a novice with access.
I am trying to build a query that groups by Weekending date. I am able to get it group and show the week number by using the following code :
Earned Date: DatePart("ww",[TK_PULLED],2)
I want it to group the same way, but show the short date of the week ending. I have googled a lot and the info ive researched seems overly complex. Is there a simple way to slide the format function into the above code to get it to show the weekending date as what its grouped by?
TIA!
I am a novice with access.
I am trying to build a query that groups by Weekending date. I am able to get it group and show the week number by using the following code :
Earned Date: DatePart("ww",[TK_PULLED],2)
I want it to group the same way, but show the short date of the week ending. I have googled a lot and the info ive researched seems overly complex. Is there a simple way to slide the format function into the above code to get it to show the weekending date as what its grouped by?
TIA!