using calculations in queries

[EWIG]

Hi,


Can a calculation field be created to add a selection of data? I have 7 colomun headings and need to add only some but the calculation I am writing is changing as I add a new field e.g Potential Completion:[current]+[left] is returning a result but as soon as I add a further +[suspended] the result I had previously is disappearing and only the rows with all current left and suspended are being calculated. any ideas?

[June7]

Arithmetic with Null results in Null. If Null is possible, handle with Nz()

Nz([current],0) + Nz([left],0) + Nz([suspended],0)

[EWIG]

Oh my goodness was it that simple, All sorted.
I wonder if that total can be shown as a percentage figure? calculation I currently have is: Potential Completion: Nz([current],0)+Nz([left],0)+Nz([suspended],0)+Nz([left compl pass],0)+Nz([susp abeyance],0)+Nz([susp break],0)+Nz([susp debt],0)

[June7]

A percentage of what? Is each of those values already a percentage (or a decimal)?