-
Aug 28th, 2016, 11:41 AM
#1
Thread Starter
New Member
[RESOLVED] how to group dates from ms access database as week of month using excel vba
I am using MS access 2010 database and working with Excel VBA to connect to the database and make queries. Suppose I have a table named "MyTable" like this below:
Date |
Count |
7/7/2016 |
12 |
7/8/2016 |
15 |
7/15/2016 |
18 |
7/18/2016 |
16 |
8/7/2016 |
15 |
8/8/2016 |
10 |
8/15/2016 |
9 |
8/16/2016 |
18 |
Now I want to use query to get a table like this:
Week by Month |
Sum |
July Week 2 |
27 |
July Week 3 |
18 |
July Week 4 |
16 |
Aug Week 2 |
25 |
Aug Week 3 |
27 |
Please help.
Last edited by meghdut; Aug 28th, 2016 at 11:58 AM.
Reason: grammatical mistake
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|