Report Blank Totals

[Luis]

Hi:

I have found a previous posting, but it relates to
subreports totals...I tried to apply it to my report, but
it does not work...

The following is my problem:

I have two totals in my report which are come from the
sum of various items...when I do a grand total and one of
my totals has no value because it has no records, it
gives me blank...
Ex:
The following works:
Code Type Profit
LB72 Drug $30
LB65 Drug $30
ML30 Non-Drug $10
ML20 Non-Drug $10 Formula Used txt Bx Nam
Drug Total $60 =Sum([Drug Profit]) 51
Non-Drug Total $20 =Sum (Non-Drug Profit]) 53
Grand Total $80 =([Text51]+[Text 53])

But if I have no values for Non-Drug, my results look
this way:
Drug Total $60
Non-Drug Total
Grand Total
They are all blank...

I appreciate all your assistance...It has been great...

Thank you

 

[Allen Browne]

Use Nz() to tell Access to use a zero for null:
=Nz([Text51],0) + Nz([Text 53],0)

Set the Format property of these calculated controls to Currency.

 

[Luis]

Thank you so much...it works

-----Original Message-----
Use Nz() to tell Access to use a zero for null:
=Nz([Text51],0) + Nz([Text 53],0)

Set the Format property of these calculated controls to Currency.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have found a previous posting, but it relates to
subreports totals...I tried to apply it to my report, but
it does not work...

The following is my problem:

I have two totals in my report which are come from the
sum of various items...when I do a grand total and one of
my totals has no value because it has no records, it
gives me blank...
Ex:
The following works:
Code Type Profit
LB72 Drug $30
LB65 Drug $30
ML30 Non-Drug $10
ML20 Non-Drug $10 Formula Used txt Bx Nam
Drug Total $60 =Sum([Drug Profit]) 51
Non-Drug Total $20 =Sum (Non-Drug Profit]) 53
Grand Total $80 =([Text51]+[Text 53])

But if I have no values for Non-Drug, my results look
this way:
Drug Total $60
Non-Drug Total
Grand Total
They are all blank...

I appreciate all your assistance...It has been great...

Thank you

.