Re: Null value problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks Ofer,

Tried that but it does not work!, any other suggestions?

"Ofer" <Ofer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DEE81D04-21CE-4DB6-9A05-6B9755A6F643@xxxxxxxxxxxxxxxx
> To the NZ function add a value you want to replace the null
> =Nz(rptEcom.Report!txtecom_total,0)
>
> "LJG" wrote:
>
>> Hey Guys,
>>
>> I am completing a summary on a report and getting values form other
>> subreports. I have tried:
>>
>> =Nz(rptEcom.Report!txtecom_total)
>>
>> But keep getting #error message in the field, can anyone tell me the
>> correct
>> way to structure this please.
>>
>> TIA
>>
>> Les
>>
>>
>>


.

Relevant Pages

  • Add Update Records
    ... >Anyone help me with this add/update ... >TIA ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Add Removve Programs doesnt work
    ... > Add Remove Programs in Control panel doesn't open up. ... No error message. ... > TIA ... Prev by Date: ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Logic command IF/OR
    ... > The above formula gives me an error message, is it possible to do what ... > TIA ... > G_Chem's Profile: ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • 1606
    ... I'm installing Microsoft Antispyware but I get the error message " 1606 ... TIA ... Prev by Date: ...
    (microsoft.public.windowsxp.general)
  • WTD: HP1930 screen
    ... My lcd is broken but the touch screen is ... TIA ... Les ... Prev by Date: ...
    (comp.sys.handhelds)