Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    90

    Unanswered: calculate total based on subform

    Hi guys,

    I have one subform where at there will appear a list of qty after user key in the number in the text box(not in subfrom).For example, let say user key in number 1, then the list of quantity that related to that number will appear on the subform. So how can I calculate the total of that list.I assume to use one new text box. is that ok?if another choice pls tell me..and how? anyway please give suggestion..

  2. #2
    Join Date
    Sep 2004
    Location
    Dallas, TX
    Posts
    77
    for my project, i create a new text box in header of subform, then use
    sum (column name)

  3. #3
    Join Date
    Nov 2004
    Posts
    90
    hello huela,

    Can u show me how the process of calculation that u have done in ur project so that more easier for me to understand ur msg..I dont understand which column to be added and at where to set it?what formula thats suitable can be used to calculate the total from list of subform?anyone have an idea pls help...
    Last edited by oasislah; 11-06-04 at 02:01.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •