Recent content by ApplePie

I analyse things by the date they are ordered by the office. The date gets put into a spreadsheet and i import this into access for the querying. I need to summarise it by weeknumber and year. I use the following queries: To get the week: Week Number: DatePart("ww",[DateOrdered],0,2) To...