Help with syntax

[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?

 

[Dirk Goldgar]

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?

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

=Sum([sglAddToInv])

 

[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?

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

    =Sum([sglAddToInv])

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.

 

[TeeSee]

news:[email protected]...

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?

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

    =Sum([sglAddToInv])

(please reply to the newsgroup)

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 -

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