Sum Up Amount

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

Mavis

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

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


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

Mavis

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

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


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!
 

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