Results 1 to 5 of 5
  1. #1
    gostap is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2017
    Posts
    30

    report problems

    As a novis I must ask for help....I have a report I want to show sorted by User, month and date. however, I cant get this to work?
    I could sort by month but the date is not right...And when I sorted by month, for example, July comes after august...what do I wrong??strippedreport.zip

  2. #2
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    9,277
    use the month function - it will return a number 1 for Jan, 2 for Feb etc

    and if it goes over years you also need the year - something like

    (year(myDate)*100)+month(myDate)

    or

    format(myDate,"yyyymm")

  3. #3
    gostap is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2017
    Posts
    30
    Quote Originally Posted by Ajax View Post
    use the month function - it will return a number 1 for Jan, 2 for Feb etc

    and if it goes over years you also need the year - something like

    (year(myDate)*100)+month(myDate)

    or

    format(myDate,"yyyymm")
    Sorry, not sure what you mean? Should I have this expression in the query? I cant get it work at all....

  4. #4
    gostap is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2017
    Posts
    30
    The query works as i t should but when i try to make a report alit will not sort as I want

  5. #5
    gostap is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2017
    Posts
    30
    Solved..made a mistake in grouping of the report

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Report View Problems!!!
    By nj2la96 in forum Reports
    Replies: 4
    Last Post: 02-08-2016, 04:28 PM
  2. Problems w/report
    By papabill in forum Reports
    Replies: 9
    Last Post: 04-27-2015, 12:48 PM
  3. Report problems
    By BarbT in forum Access
    Replies: 3
    Last Post: 05-09-2011, 09:33 AM
  4. Problems with Report Filter
    By eww in forum Programming
    Replies: 1
    Last Post: 10-20-2010, 02:58 PM
  5. Problems with SUM in Report Footer
    By bonetakc in forum Forms
    Replies: 1
    Last Post: 07-30-2009, 04:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums