Results 1 to 4 of 4
  1. #1
    dododo is offline Novice
    Windows Vista Access 2003
    Join Date
    Jun 2011
    Posts
    26

    Angry How to calcutate sub total in form?

    Hi all,

    In form, I want to calcuate sub total(txtsubtotal) that get valule from total(txttotal).

    txttotal= Qty*Price then txtsubtotal=sum(txttotal). it won't work but if i write txtsubtotal= sum(qty*price) it works.



    How can i calcuate value direct from txttoal? please help.

    thanks.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    You can't sum a calculated control; you're doing it the correct way.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    dododo is offline Novice
    Windows Vista Access 2003
    Join Date
    Jun 2011
    Posts
    26
    Quote Originally Posted by pbaldy View Post
    You can't sum a calculated control; you're doing it the correct way.
    Thanks for your answer.

    If I want to sum a calcuated control, how to do? Absolutely, We can't ?

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    I already said you couldn't. Maybe you'll believe Microsoft.

    http://support.microsoft.com/kb/207763?wa=wsignin1.0
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. VB codes in form for Total
    By glen in forum Forms
    Replies: 8
    Last Post: 09-19-2012, 09:36 AM
  2. Display Total on a form
    By Ray67 in forum Forms
    Replies: 21
    Last Post: 06-18-2012, 03:49 PM
  3. Total Box on Form
    By Bike in forum Forms
    Replies: 3
    Last Post: 04-05-2011, 01:30 PM
  4. Rolling Total in Form
    By foxtrot in forum Forms
    Replies: 2
    Last Post: 01-26-2011, 05:45 AM
  5. Replies: 1
    Last Post: 02-04-2010, 01:15 PM

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