Results 1 to 3 of 3
  1. #1
    JackCampion is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Sep 2012
    Posts
    3

    Question Need help regarding forms and 'summing a total'.

    Hi, I'm trying to make a form and database, to hold all call logs, that a colleague can fill in with the details of the customer. I have made it so they can enter several products and their prices. What I am struggling with is creating a label/text box which automatically totals the prices together as you are typing them in. If this is not possible please suggest a suitable alternative.
    Thank you.
    Jack.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    If form is in Datasheet view, open the form (NOT in Design view) and click Totals from the ribbon. This will open a Totals row at bottom of the form. Select aggregate function below each column as desired.

    If form is in Continuous view, can have a textbox in form footer with expression: =Sum([price field])
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    JackCampion is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Sep 2012
    Posts
    3
    Thank you this worked fine. Much appreciated.

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

Similar Threads

  1. Forms and total sum- example
    By Micky in forum Forms
    Replies: 3
    Last Post: 04-08-2012, 09:43 AM
  2. Forms and Total Sums
    By Micky in forum Forms
    Replies: 2
    Last Post: 04-08-2012, 07:42 AM
  3. summing in a query
    By nparrillo in forum Queries
    Replies: 1
    Last Post: 04-11-2011, 10:37 AM
  4. summing
    By nashr1928 in forum Forms
    Replies: 18
    Last Post: 04-05-2011, 05:01 PM
  5. need help with summing a range
    By sundance0000 in forum Access
    Replies: 3
    Last Post: 01-12-2010, 02:12 PM

Tags for this Thread

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