Results 1 to 2 of 2
  1. #1
    Tom 5252 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Nov 2019
    Posts
    1

    page totals using code not design or layout view, where to find

    Trying to fix an old access data base I constructed


    In the reports I have page totals (pagesum1 and pagesum 2) on each page. The pagesum 1 seems to work (just simple add) but pagesum2 doesn't work since it is a product of pagesum1 times $6 (the old price) and now I need it to be times $20 (new price).

    I can't find where I created this formula since its not in the layout or design views of the report. I tend to remember doing some programming somewhere but can't find the place to change.

    can you help where I might have constructed this?

  2. #2
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    If it's in code, do Ctrl+F to find the name of the control in the code project. If that or similar searches don't find what you're looking for, it's likely a property of the control itself, unless you set running sum property over a field in the report design. That would be under sorting and grouping.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 10
    Last Post: 02-06-2018, 02:37 PM
  2. Replies: 1
    Last Post: 06-27-2017, 08:37 AM
  3. Replies: 18
    Last Post: 11-04-2014, 02:10 PM
  4. Replies: 6
    Last Post: 03-08-2014, 12:47 PM
  5. remove design view and layout view on right click
    By sdel_nevo in forum Programming
    Replies: 2
    Last Post: 07-11-2013, 01:00 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