Sum function error (1 Viewer)

[john3588]

Trying to so a simple sum (..) This is what the sql statement looks like.

SELECT Sheet1.Field1, Sheet1.Field2, Sheet1.Field3, Sheet1.Field4, Sheet1.Field5, Sheet1.Field6, Sheet1.Field7, Sheet1.Field8, Sheet1.Field9, Sheet1.Field10, Sheet1.Field11, Sheet1.Field12, Sheet1.Field13, Sheet1.Field14, Sheet1.Field15, Sheet1.ID, Sum([Field4]+[Field5]+[Field6]+[Field7]+[Field8]+[Field9]+[Field10]+[Field11]+[Field12]+[Field13]+[Field14]+[Field15]) AS Expr1
FROM Sheet1;

Getting error "You tried to execute a query that does not include the specified expression 'Field 1" as part of the aggregate function. I have been doing this stuff for years and it seems so simple but I am obviously missing something. Any help would be appreciated. I am not doing this with sql but I am using the query build window.

 

[vbaInet]

This should give you some insight:

https://www.youtube.com/watch?v=S86uRSb0TBw

 

[pbaldy]

If you're just trying to add those up, drop the Sum() function.

 

[john3588]

Thanks - Got it.

 

[pbaldy]

I guess I should have clarified if you're trying to add them up within each record, as opposed to across records.