Sum Up Amount

  • Thread starter Thread starter Mavis
  • Start date Start date
M

Mavis

Hi All,

I have 2 fields in a report. Invoice amount and Date Paid.
The invoice amount will always be filled but not the Date Paid.

How can i Sum Up the Invoice Amount if the Date Paid is not null???

Thanks!
 
Hi all,

I change the code to the below but it result in #ERORR.

=Sum("[Text52]"+"[Text51]"+"[Text53]")

Please advice.



Duane Hookom said:
Try:
=Sum((IsNull([Date Paid])+1) * [Invoice Amount])
--
Duane Hookom
Microsoft Access MVP


Mavis said:
Hi All,

I have 2 fields in a report. Invoice amount and Date Paid.
The invoice amount will always be filled but not the Date Paid.

How can i Sum Up the Invoice Amount if the Date Paid is not null???

Thanks!
Click to expand...
Click to expand...
 
I'm not sure how you got from my suggestion to your attempt. Did I waste my
time trying to suggest or did you actually try it? If you tried it, what were
the results?

Your expression:
=Sum("[Text52]"+"[Text51]"+"[Text53]")
attempts to sum 3 text box values which I can't relate back to your original
question.
--
Duane Hookom
Microsoft Access MVP


Mavis said:
Hi all,

I change the code to the below but it result in #ERORR.

=Sum("[Text52]"+"[Text51]"+"[Text53]")

Please advice.



Duane Hookom said:
Try:
=Sum((IsNull([Date Paid])+1) * [Invoice Amount])
--
Duane Hookom
Microsoft Access MVP


Mavis said:
Hi All,

I have 2 fields in a report. Invoice amount and Date Paid.
The invoice amount will always be filled but not the Date Paid.

How can i Sum Up the Invoice Amount if the Date Paid is not null???

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Hi,

The suggestion u given it help alot and its works.
The other one is my another question.


Duane Hookom said:
I'm not sure how you got from my suggestion to your attempt. Did I waste my
time trying to suggest or did you actually try it? If you tried it, what were
the results?

Your expression:
=Sum("[Text52]"+"[Text51]"+"[Text53]")
attempts to sum 3 text box values which I can't relate back to your original
question.
--
Duane Hookom
Microsoft Access MVP


Mavis said:
Hi all,

I change the code to the below but it result in #ERORR.

=Sum("[Text52]"+"[Text51]"+"[Text53]")

Please advice.



Duane Hookom said:
Try:
=Sum((IsNull([Date Paid])+1) * [Invoice Amount])
--
Duane Hookom
Microsoft Access MVP


:

Hi All,

I have 2 fields in a report. Invoice amount and Date Paid.
The invoice amount will always be filled but not the Date Paid.

How can i Sum Up the Invoice Amount if the Date Paid is not null???

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
If there was a new question there, I missed it. You might want to start a new
thread if you have a new question.
--
Duane Hookom
Microsoft Access MVP


Mavis said:
Hi,

The suggestion u given it help alot and its works.
The other one is my another question.


Duane Hookom said:
I'm not sure how you got from my suggestion to your attempt. Did I waste my
time trying to suggest or did you actually try it? If you tried it, what were
the results?

Your expression:
=Sum("[Text52]"+"[Text51]"+"[Text53]")
attempts to sum 3 text box values which I can't relate back to your original
question.
--
Duane Hookom
Microsoft Access MVP


Mavis said:
Hi all,

I change the code to the below but it result in #ERORR.

=Sum("[Text52]"+"[Text51]"+"[Text53]")

Please advice.



:

Try:
=Sum((IsNull([Date Paid])+1) * [Invoice Amount])
--
Duane Hookom
Microsoft Access MVP


:

Hi All,

I have 2 fields in a report. Invoice amount and Date Paid.
The invoice amount will always be filled but not the Date Paid.

How can i Sum Up the Invoice Amount if the Date Paid is not null???

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top