field is populated by the total of 5 other fields

[Callum]

hello,

as stated in the title i would like to sum up 5 fields and save (or just show it in the form view is enough really) in a seperate field, i have managed to sum the 5 fields, but it summed up all 5 fields in all records, i'd like to have my form show the sum for the record, not the table.

it would be ideal that it would refresh when one of the 5 fields data changes, i.e from 1000 to 2000. again updating in the form view is what is needed.




thanks,
Cal

 

[CazB]

As a simple solution, if all you want to do is 'show' the total value, then an unbound control on the form should do the trick.

As its source, just put something like =[field1]+[field2]+[field3]+[field4]+[field5]
where field1-5 are the fields you want to add up...

 

[pbaldy]

No Sum(), just add:

= Field1 + Field2 + ...

 

[Callum]

ok tryed your example CazB works perfectly, looks like i thought it was more awkward than it should have :banghead:

 

[CazB]

it should update automatically when any of the fields values change

 

[Pat Hartman]

@callum -
It is awkward because Relational databases are not spreadsheets and so don't offer "across" functions. Since the implication of an "across" function is that you have a repeating group which violates first normal form. A relational database will never offer a feature that violates normal forms. Your problem may be caused because your data is a repeating group and should be stored in a separate table rather than as columns.