Text Box Total

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hello, I am a bit frustrated,

I have a report that in the detail footer section I have two textboxes that
sum two feilds in the detail section.. [Credit] and [Debit] If I add a
third text box in the detail footer section like this [credit]-[Debit] it all
works fine if there is a total in both text boxes.. What I can not understand
is if [Credit]=50 and [Debit]=0 then I should get a balance of 50.. Nothing
is shown.. The text box field for the balance is blank... How can I fix this..

Thanks
Bob
 
Bob said:
I have a report that in the detail footer section I have two textboxes that
sum two feilds in the detail section.. [Credit] and [Debit] If I add a
third text box in the detail footer section like this [credit]-[Debit] it all
works fine if there is a total in both text boxes.. What I can not understand
is if [Credit]=50 and [Debit]=0 then I should get a balance of 50.. Nothing
is shown.. The text box field for the balance is blank... How can I fix this..
Click to expand...


Try using:

=Nz(Credit ,0) - Nz(Debit,0)
 
Worked like a charm, I am sort of mad at myself as I should have known that
was the problem..

Oh well another bad day.

Thanks

Marshall Barton said:
Bob said:
I have a report that in the detail footer section I have two textboxes that
sum two feilds in the detail section.. [Credit] and [Debit] If I add a
third text box in the detail footer section like this [credit]-[Debit] it all
works fine if there is a total in both text boxes.. What I can not understand
is if [Credit]=50 and [Debit]=0 then I should get a balance of 50.. Nothing
is shown.. The text box field for the balance is blank... How can I fix this..
Click to expand...


Try using:

=Nz(Credit ,0) - Nz(Debit,0)
Click to expand...
 
Back
Top