sum of calculated field in form (1 Viewer)

webnomad

New member
Local time
Today, 19:04
Joined
Mar 12, 2014
Messages
2
Hello,
I have a form with three fields named 'quantity' (numberfield), 'service' (combo box) and 'amount' (calculated field with controlsource =[service].[Column](2)*[quantity].

I try to sum the amount field in the formfooter with =Sum([service].[Column](2)*[quantity]) but I receive an error. Somehow it does not get the value for [service].[Column](2)

How can I do this?

The table for the form is called customer_detail

Thanx for any input
 

pr2-eugin

Super Moderator
Local time
Today, 18:04
Joined
Nov 30, 2011
Messages
8,494
Try Sum(theControlName), which holds the formula. What is the Form view set up as??
 

webnomad

New member
Local time
Today, 19:04
Joined
Mar 12, 2014
Messages
2
Hi Paul, thanx for the answer, the form is set up as Datashhet ( its a subform). i had the field configured wrongly in the table, works fine now
 

Users who are viewing this thread

Top Bottom