Sum Up Amount

[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!

 

[Duane Hookom]

Try:
=Sum((IsNull([Date Paid])+1) * [Invoice Amount])

 

[Mavis]

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!

 

[Duane Hookom]

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

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!

 

[Mavis]

Hi,

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

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

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!

 

[Duane Hookom]

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

Hi,

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

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

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!