CODEWITHSUNDEEP
vb.netvbams-accessgrouping
Billy Otsuka
Billy Otsuka

Reputation: 21

weekly query grouping visual basic ms access

I need some help on how to group my data into weekly reports. I have asked for a monthly and yearly a month ago but I can't figure out how to do the weekly reports in the same style.

I don't have any idea too what output is good to show a weekly report, but maybe like this?

Week_Sold           Total_Earnings
January 1 2013           1
January 8 2013           5

Or like this?

Week_Sold            Total_Earnings
January 1st Week          5
January 2nd Week          8

Or like this?

Week_Sold            Total_Earnings
January 1-7               5
January 8-15              8

I have no idea what to do on this weekly so can someone recommend me a good weekly report format?

btw, my grouping is the same as the answer on this one Yearly, monthly grouping Visual Basic so please try to make the procedures close to this since im no good on Microsoft Access or Visual Basic.

Upvotes: 0

Views: 580

Answers (1)

RJ Moeller
RJ Moeller

Reputation: 499

Have you tried 

 Format([YourDateColumn], "ww")

?

This should give you the weeknumber in ISO standard. There are also some additional switches; you should find those easily in VBA.

Upvotes: 1

Related Questions