Hi fine folks of Access Brain land!
I have been given this Db by my boss (who was given it by someone else!!! - can you see where this is going!) basically someone has built(!) this query that adds up how many times one of four yes/no boxes has been tick. So ultimately you can end up with an answer like Option 1 - 10 times, Option 2 - 6 times, Option 3 - 3 times, Option 4 - 0 times (the default value is 0) - this is taken from the datasheet view (I think that is the right word!)
What I have been asked to do is make these little, small figures add up so that in column number 5 (which doesn't exist at the moment) reads 19 (taking the figures from above)
I went into the design view and added Totalfigure: Nz([Option1],0) + Nz([Option2],0) + Nz ([Option3],0 +([Option4],0) into the Field section and .....
It didn't work!
please help a poor hassled worker keep his job!
Cheers Mundo all