Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can you total columns in a continuous form ?

Status
Not open for further replies.

grobermatic

Technical User
Dec 21, 2002
153
GB
Hi,

I have a continuous form as a subform which contains invoice data and I want to perform calculations on the amount (£) field. Talking in Excel terms I want to sum the columns. Is this possible??

Cheers

Craig

--------------------------------------------------------------------------------------------------------
"Time-traveling is just too dangerous. Better that I devote myself to study the other great mystery of the universe: Women!" .. Dr E. Brown (1985)
 
Hi!

Create an unbound text control on your form with the controlsource of

[tt]=Sum([FieldName])[/tt]

Roy-Vidar
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top