Firstly can i apologise for the vagueness of this post but I am a complete Noob with this sort of thing... here goes
I have a report which I am trying to add a total for multiple fields from a query
The query fields are calculated by the following
Improved Confident: IIf([Initial Assessment - Confident]>[6 Wk / 6 Mth Assessment - Confident],"1","0")
Whenever I use the following it does not sum the values together but simply lists the values
=Sum([Improved Confident]+[Same Confident]+[Not Improved Confident])
Help would be greatly appreciated as the hairless patch on my head is stating to grow!