Query query

[Guest]

I am trying to create a new field in which it shows the sum total of 10
fields (Charge Time, Charge Time 2, Charge Time 3, etc.); what is the easiest
way to do this?

 

[Guest]

NewFieldName: [Charge Time] + [Charge Time 2] + [Charge Time 3] .... etc

 

[Guest]

I tried this, and it doesn't work. Is there something I'm forgetting?
--
Joe

NewFieldName: [Charge Time] + [Charge Time 2] + [Charge Time 3] .... etc

--
Good Luck
BS"D

I am trying to create a new field in which it shows the sum total of 10
fields (Charge Time, Charge Time 2, Charge Time 3, etc.); what is the easiest
way to do this?

 

[Guest]

Do you have Null in some of the fields? if that the case use the Nz function
to replace null with 0

Nz([Charge Time],0) + Nz([Charge Time 2],0) + ....

--
Good Luck
BS"D

I tried this, and it doesn't work. Is there something I'm forgetting?
--
Joe

NewFieldName: [Charge Time] + [Charge Time 2] + [Charge Time 3] .... etc

--
Good Luck
BS"D

I am trying to create a new field in which it shows the sum total of 10
fields (Charge Time, Charge Time 2, Charge Time 3, etc.); what is the easiest
way to do this?

 

[Guest]

Thank you! It worked!
--
Joe

Do you have Null in some of the fields? if that the case use the Nz function
to replace null with 0

Nz([Charge Time],0) + Nz([Charge Time 2],0) + ....

--
Good Luck
BS"D

I tried this, and it doesn't work. Is there something I'm forgetting?
--
Joe

NewFieldName: [Charge Time] + [Charge Time 2] + [Charge Time 3] .... etc

--
Good Luck
BS"D


:

I am trying to create a new field in which it shows the sum total of 10
fields (Charge Time, Charge Time 2, Charge Time 3, etc.); what is the easiest
way to do this?