Results 1 to 4 of 4
  1. #1
    pdxrichard is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    5

    Access 2016 >> Need a way to change a row's data and move row to bottom of report

    Please see image. I keep getting "can't change object" message when I try to change the detail items during the detail formatting.
    I need for the row to appear at the bottom since it is a total row. I couldn't use normal footer totals as that would be easier but won't work in this case.

    Thank you!
    Attached Thumbnails Attached Thumbnails Capture.png  

  2. #2
    Bulzie is online now VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    You should be able to use Sorting and Grouping(right click in detail section) to sort by that percent field.

  3. #3
    pdxrichard is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    5
    I get that. I am sorting it the way I want but I want the 100% to be the only record at the bottom as the total record - so the rest would be descending order.

  4. #4
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    In the query for the report (you ARE using a query....right????), add a calculated column
    Code:
    Seq: IIf(InStr([TestDesc],"Totals")>0,100,1)
    ' (Seq = sequence)
    Change "TestDesc" to the name of the column that has the text "Liniedge Totals".

    Any record that has the word "Totals" in the text in that field will have 100, all other records will have 1. Sorted ascending will put the "Totals" record at the 'bottom'.

    Do the grouping, then make sure the "Seq" column is the first in the sort order.......

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

Similar Threads

  1. Replies: 1
    Last Post: 03-03-2017, 09:25 PM
  2. Replies: 2
    Last Post: 11-13-2016, 08:15 AM
  3. report printing in Access 2016
    By cfljanet in forum Reports
    Replies: 12
    Last Post: 11-02-2016, 10:28 AM
  4. Replies: 0
    Last Post: 09-10-2016, 11:55 AM
  5. Replies: 3
    Last Post: 05-30-2013, 08:03 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