<div>
Where do you have that expression?<br />
<br />
mx
</div>


<div>
In a text box which is on the same row as I'm trying to sum.
</div>


In a text box which is on the same row as I'm trying to sum.

<div>
If ... in a Control Source of a text box, the general syntax is:<br />
<br />
=Sum([Field1]+[Field2]+ .....)<br />
<br />
where Field 1/2 are fields in the record source of the form, not the name of text boxes.<br />
<br />
mx
</div>


If ... in a Control Source of a text box, the general syntax is:

=Sum([Field1]+[Field2]+ .....)

where Field 1/2 are fields in the record source of the form, not the name of text boxes.

mx

<div>
I'm using the same syntax, the issue is that I'm summing a row of a 'tabular' form. Thanks.
</div>


I'm using the same syntax, the issue is that I'm summing a row of a 'tabular' form. Thanks.

<div>
use nz to handle nulls<br />
<br />
=sum(nz([Field1]) +nz([Field2]) + nz([Field3]))
</div>


use nz to handle nulls

=sum(nz([Field1]) +nz([Field2]) + nz([Field3]))

<div>
The key is .... across the Row, right?<br />
<br />
either =([Field1]+[Field2]+ .....)<br />
<br />
or<br />
<br />
=([textbox1]+[textbox2]+ .....)<br />
<br />
mx
</div>


The key is .... across the Row, right?

either =([Field1]+[Field2]+ .....)

or

=([textbox1]+[textbox2]+ .....)

mx

<div>
<div class="content wysiwyg-content">
I'm trying to sum the rows on my tabular form but =Sum([1]+[2]+[3]) doesn't work. It's easy enough to sum columns but I could do with help with rows.<br />
<br />
Thanks.
</div>
</div>


I'm trying to sum the rows on my tabular form but =Sum([1]+[2]+[3]) doesn't work. It's easy enough to sum columns but I could do with help with rows.

Thanks.

Access Tabular Form - Sum Rows

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.