Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2004
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Weekly formula (Access 97)

    I am creating a query that needs to calculate production statistics on a weekly basis. I only see a way in Access 97 to summarize the data into daily, monthly, quarter, yearly batches. Is there a way to change the following formula (which is monthly) so that it will gather the data in weekly increments?

    Date By Month: Format$([Data].[Date],"mmmm yyyy")

    I am in just the beginning stages of learning to program and I cannot get this one figured out.
    Heath

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Weekly formula (Access 97)

    You could use

    Date by Week: Format([Data].[Date], "ww yyyy")

    Note: I always avoid naming a field in a table Date, since Date is also a function that can be used in queries.

  3. #3
    New Lounger
    Join Date
    Dec 2004
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Weekly formula (Access 97)

    Thanks that got me in the direction I was going.
    Heath

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •