Results 1 to 5 of 5

Thread: [RESOLVED] how to group dates from ms access database as week of month using excel vba

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2016
    Posts
    8

    Resolved [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
  •  



Click Here to Expand Forum to Full Width