Help with syntax

  • Thread starter Thread starter TeeSee
  • Start date Start date
T

TeeSee

Access 2003
Name of subform = transactions
fieldname = sglAddToInv

All I want to do is to add the values in that field. The folowing
expression within the control source of an unbound text box returns
the value in the first record ..... So something works

=[Transactions].[Form]![sglAddToInv]
Once I add SUM to the front of it in order to add the values I get
nothing but errors no matter what I try.

eg =Sum([Transactions].[Form]![sglAddToInv])

Could some one suggest something for me please?
 
TeeSee said:
Access 2003
Name of subform = transactions
fieldname = sglAddToInv

All I want to do is to add the values in that field. The folowing
expression within the control source of an unbound text box returns
the value in the first record ..... So something works

=[Transactions].[Form]![sglAddToInv]
Once I add SUM to the front of it in order to add the values I get
nothing but errors no matter what I try.

eg =Sum([Transactions].[Form]![sglAddToInv])

Could some one suggest something for me please?
Click to expand...


In the Form Footer or Form Header section of the subform, put a text box
with this controlsource:

=Sum([sglAddToInv])
 
Access 2003
Name of subform = transactions
fieldname = sglAddToInv
Click to expand...
All I want to do is to add the values in that field. The folowing
expression within the control source of an unbound text box returns
the value in the first record ..... So something works
Click to expand...
=[Transactions].[Form]![sglAddToInv]
Once I add SUM to the front of it in order to add the values I get
nothing but errors no matter what I try.
Click to expand...
eg =Sum([Transactions].[Form]![sglAddToInv])
Click to expand...
Could some one suggest something for me please?
Click to expand...

In the Form Footer or Form Header section of the subform, put a text box
with this controlsource:

    =Sum([sglAddToInv])
Click to expand...

Sorry for wasting your time.... However I somehow omitted to say that
the subform is filtered by a "SELECT DISTINCT" combo box on the header
of the main form. I would also like to have the calculated text box on
the footer of the main form. Thanks for the response.
 
news:[email protected]...
Click to expand...
Access 2003
Name of subform = transactions
fieldname = sglAddToInv
All I want to do is to add the values in that field. The folowing
expression within the control source of an unbound text box returns
the value in the first record ..... So something works
=[Transactions].[Form]![sglAddToInv]
Once I add SUM to the front of it in order to add the values I get
nothing but errors no matter what I try.
eg =Sum([Transactions].[Form]![sglAddToInv])
Could some one suggest something for me please?
Click to expand...
Click to expand...
In the Form Footer or Form Header section of the subform, put a text box
with this controlsource:
Click to expand...
    =Sum([sglAddToInv])
Click to expand...
(please reply to the newsgroup)
Click to expand...

Sorry for wasting your time.... However I somehow omitted to say that
the subform is filtered by a "SELECT DISTINCT" combo box on the header
of the main form. I would also like to have the calculated text box on
the footer of the main form. Thanks for the response.- Hide quoted text -

- Show quoted text -
Click to expand...

Dirk The light finally came on and I Got It! I missed the fact you
said the SubForm. Many thanks
 
Back
Top