Re: Calculate sum of each field for each record in recordset

Yes,

that's exactly what I was thinking. I'm working on a survey. For each
query, there is a dependant variable and each field contains an average
of the totals for each question grouped by the dependant variable.
However, I need a create a field that does indeed do what you
mentioned, create a sum of the fields of the fields for each record.

Thanks,
Laryy

Terry Kreft wrote:

Select F1, F2, F3, (F1 + F2 + F3) As LineTotal
From Table1



--

Terry Kreft


"larry" <allanrodkin@xxxxxxxxx> wrote in message
news:1158262245.724698.120970@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

Is there a way to calculate the sum of the numbers in each field for
each record in the recordset returned from the query? Do I have to use
VBScript?

Thanks,
Larry


.

Relevant Pages