Hi,

I have been using this to add up 6 fields from a table giving the total:


[Assist]+[Clean Sheet]+[Goal]+[Hatrick Bonus]+[Penalty Save] AS Total
FROM [Weekly Scoring]


But instead of adding them up it puts them together. e.g. > fields are 2,3,4,5,6. The total field shows 23456 instead of 30. Why?

Have I got my syntax wrong?

Scott.

My mistake, I had the fields as text field instead of numeric.

Bloody fool!