Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2004
    Posts
    178

    Unanswered: change start of week to friday

    i want to be able to change the start of week in a report to a friday i only seem to be able to set it to monday of sunday

    Than ks for your help

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    ???????????????????
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by pkstormy
    ???????????????????
    What he said
    Anything to do with this thread?
    George
    Home | Blog

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    I think Paul was being way, way too low key! Should have been
    ?????????????????????????????????????????????????? ???????????

    You'll notice the other "Friday" posting has never been replied to, despite it being about 3 posts down from this one when placed here!
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    Join Date
    Aug 2004
    Posts
    178
    the other post was replyed to and i got the answer i needed to try and do my reports.

    the place where the database is going there week starts on a friday all the new stuff comes in on friday.

    what i was trying to do is create a report where i could groub by week so i could compare 1 month to another.

  6. #6
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    Read any of the help entries for a function that uses the "firstdayofweek" constant, for example the Weekday() function. Click on SeeAlso, and you can get from there to any other similar function. Using any day as the first day is simple. We always take it for granted that it's Sunday, which doesn't need the argument at all because it's the default.

    Hope this helps,

    Sam

Posting Permissions

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