Text Box Total

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
 
M

Marshall Barton

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..


Try using:

=Nz(Credit ,0) - Nz(Debit,0)
 
B

Bob

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..


Try using:

=Nz(Credit ,0) - Nz(Debit,0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top