Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Moundridge, Kansas, USA
    Posts
    342
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Order Total (Access 2003/SP 1)

    I need to have a running total for my order. I cannot figure out what I am doing wrong. Can someone help me? The Text69: field is what I would like to sum the order for me, but it only sums the first field in the subform.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Order Total (Access 2003/SP 1)

    You can create a running total in two steps - see attached version.

    Source: How to create a running totals query in Microsoft Access

  3. #3
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Moundridge, Kansas, USA
    Posts
    342
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Order Total (Access 2003/SP 1)

    I think I mis-spoke myself when I said I want a running total. The subform works how I want it to. All I need is the text69: field (I'll rename it when I get it figured out) to give me a sum of my order. I appreciate the help on the running total though!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Order Total (Access 2003/SP 1)

    Try this as control source:

    =[sbfOrder Details]!Text20

  5. #5
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Moundridge, Kansas, USA
    Posts
    342
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Order Total (Access 2003/SP 1)

    Thanks a lot for your help! That worked. Can you explain to me the difference in function of the '.' and the '!'? I had the control source like this =[sbfOrder Details].Text20 first and that didn't work.

  6. #6
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Moundridge, Kansas, USA
    Posts
    342
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Order Total (Access 2003/SP 1)

    Thanks for the explanation!

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Order Total (Access 2003/SP 1)

    The bang ! denotes a member of a collection, and the period . a property. In this case, you can use

    =[sbfOrder Details].[Form]![Text20]

    or

    =[sbfOrder Details].[Form].[Text20]

    or

    =[sbfOrder Details]![Text20]

    but not

    =[sbfOrder Details].[Text20]

    A control is a property of a form, and hence of the form object in the subform, but it is not a property of the subform as a control on the main form.
    A control is also a member of the Controls collection of a form, but since Controls is the "default" property of a form, you can omit the word Controls.

  8. #8
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Order Total (Access 2003/SP 1)

    You are coming dangerously close to turning this into a Glibert and Sullivan response. Clearly you know too much...
    <img src=/S/noevil.gif border=0 alt=noevil width=25 height=17>

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Order Total (Access 2003/SP 1)

    <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29> <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

Posting Permissions

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