sum of fields in a table

[AlexUK]

i would like to have a field which totalled monthly figures entered into the same table. should i use a query or is there a better way?<br><br>TIA

 

[WaltLukeIII]

A Select Query is the simplest way to do it unless you have a form where data is entered in and then it would be simpler to put it in there <p>Walt III<br><a href=mailto:SAElukewl@netscape.net>SAElukewl@netscape.net</a><br><a href=

http://www.muc.edu/~lukewl>homepage</a><br>

 

[AlexUK]

is there no way of configuring the 'totals field' to generate a figure based on previous entries in the preceding monthly fields?

 

[WaltLukeIII]

In the table I don't know of a way to do that But in a form you can set a field to <br><br>=Sum(table!one![field1]+table!one![field2]) <br>then set the field in the table equal to that field in the form.<br><br>that would be the only way that I can think of <p>Walt III<br><a href=mailto:SAElukewl@netscape.net>SAElukewl@netscape.net</a><br><a href=

http://www.muc.edu/~lukewl>homepage</a><br>

 

[AlexUK]

thanks for your help, much appreciated.<br><br>alex