Counting Columns in a Query

[bellevue]

I hope someone can help; I've had a look to see if I can find a solution in a previous post but son't think it's there.



I have created a query; in that query there are a number of columns; I want to calculate the total of 6 of those columns and place the total in the 7th column called "Total Payment Charges", I have shown the first two columns below:




I have tried the following formula:

Total Payment Charges: [Brks Deductions]+[Brks Deductions 1]+[Brks Deductions 2]+[Brks Deductions 3]+[Brks Deductions 4]+[Brks Deductions 5]

...but when I run the query the result I get looks like this:


I wonder if the £0.00 values in some columns are causing the issue or, if not, what could be the problem; any help would be appreciated please ?

Thanks

[ssanfu]

It looks like the field values are being concatenated. Have you tried running the query with the Format() function removed? Note that it doesn't hurt to have additional columns that are unformated if you need the formatted values.

[bellevue]

Hello Steve

I am so sorry it's taken me so long to reply to this, I feel really bad but I've been juggling so many projects and spinning plates that, inevitably, this plate felll off.

Having returned to this project, I find that your solution was perfect and everything is working well now; thank you so much.

I've added to your reputation and marked this one as solved.

Merci beaucoup