Results 1 to 2 of 2
  1. #1
    shod90 is offline Competent Performer
    Windows 8 Access 2016
    Join Date
    Jan 2016
    Posts
    134

    Counting values then display the sum

    Dear Gents,
    Um trying to make an app. which manage orders for market.
    So , If the user chooses say 4 items , Then it should display the total at the bottom of the page dynamically , and if the user remove any item it again updates automatically .
    How to do that process ?

  2. #2
    sstiebinger is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2015
    Posts
    105
    I'm assuming the items will be displayed in a continuous form, then simply place a text box in the form header or form footer (NOT the page header/footer).
    If the field for the individual items were "Price" your text box control source would be
    Code:
    =Sum([Price])
    then be sure to set the format for the text box to Currency.

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

Similar Threads

  1. Help With Counting values in query
    By MFS in forum Queries
    Replies: 2
    Last Post: 11-14-2015, 08:37 AM
  2. Counting null values as Zero
    By missypooh1969 in forum Queries
    Replies: 6
    Last Post: 08-07-2014, 02:05 PM
  3. Counting values after a specific value
    By cardgage in forum Queries
    Replies: 5
    Last Post: 03-12-2013, 07:41 AM
  4. counting values
    By webisti in forum Access
    Replies: 1
    Last Post: 11-18-2011, 07:28 AM
  5. help counting distinct values
    By joo-joo-man in forum Queries
    Replies: 2
    Last Post: 10-17-2010, 05:18 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