Query query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
I tried this, and it doesn't work. Is there something I'm forgetting?
--
Joe


Ofer Cohen said:
NewFieldName: [Charge Time] + [Charge Time 2] + [Charge Time 3] .... etc

--
Good Luck
BS"D


joet5402 said:
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?
Click to expand...
Click to expand...
 
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


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


Ofer Cohen said:
NewFieldName: [Charge Time] + [Charge Time 2] + [Charge Time 3] .... etc

--
Good Luck
BS"D


joet5402 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Thank you! It worked!
--
Joe


Ofer Cohen said:
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


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


Ofer Cohen said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top