Adding up query problem

[expublish]

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.

 

[expublish]

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

Bloody fool!