I have a report and in the Detail section I have  4 columns.  The first 
column is ExpenseCategory containing  Repairs, Water, Electricity etc.  
The next column named Budget,has the amount budgeted for each category.  
The third column called ActualExpenditure has actual expenditure for each 
category  while the last column has the calculated expression 
ActualExpenditure/Budget *100.

One category TaxPaid, has nothing entered for ActualExpenditure so the 
calculated field is giving #Error result.
I tried several ways to remove this error but cannot.  Two examples are 
shown.

=IIf(IsError([ActualExpenditure]/[Budget]*100),0,[ActualExpenditure]/
[Budget]*100)
=Nz([ActualExpenditure]/[Budget]*100)

How can I remove the #Error

<<One category TaxPaid, has nothing entered for ActualExpenditure so the
calculated field is giving #Error result.
I tried several ways to remove this error but cannot.  Two examples are
shown.>>

instead of:


=IIf(IsError([ActualExpenditure]/[Budget]*100),0,[ActualExpenditure]/
[Budget]*100)
=Nz([ActualExpenditure]/[Budget]*100)


try:



=IIf(Not IsNull([ActualExpenditure]) and NZ([ActualExpenditure]),
[ActualExpenditure]/[Budget]*100, 0)



i.e. if ActualExpenditure is not zero and is not null (probably NZ on its
own is sufficient) then multiply that by the budget, otherwise derive a
ZERO result





*************************************************************************

This e-mail may contain confidential information or be privileged. It is intended to be read and used only by the named
recipient(s). If you are not the intended recipient(s) please notify us immediately so that we can make arrangements for its return:
you should not disclose the contents of this e-mail to any other person, or take any copies. Unless stated otherwise by an
authorised individual, nothing contained in this e-mail is intended to create binding legal obligations between us and opinions
expressed are those of the individual author.

The CIS marketing group, which is regulated for Investment Business by the Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R - for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965  - for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 3390839 - for ISAs and investment products bearing the CIS
name
Registered offices: Miller Street, Manchester M60 0AL   Telephone  0161-832-8686   Internet  http://www.cis.co.uk   E-mail
cis@c...

CIS Deposit and Instant Access Savings Accounts are held with The Co-operative Bank p.l.c., registered in England and Wales number
990937, P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS Policyholder Services Limited as agent of the
Bank.

CIS is a member of the General Insurance Standards Council

CIS & the CIS logo (R) Co-operative Insurance Society Limited

********************************************************************************

have you tried ISNULL  - use this to check the value in the field before you
try to do the maths on it.





Regards

Richard Gibson
IT Manager


The information in this message is confidential and intended for the
addressee only.  If you have received this message in error please delete
and notify the sender, any other action may be unlawful.

The views expressed in this message are personal and not necessarily those
of Walkerpack Ltd unless explicitly stated.


-----Original Message-----
From: Howard Stone [mailto:ququmber@h...]
Sent: 26 April 2002 14:34
To: Access
Subject: [access] #Error in detail section of form


I have a report and in the Detail section I have  4 columns.  The first 
column is ExpenseCategory containing  Repairs, Water, Electricity etc.  
The next column named Budget,has the amount budgeted for each category.  
The third column called ActualExpenditure has actual expenditure for each 
category  while the last column has the calculated expression 
ActualExpenditure/Budget *100.

One category TaxPaid, has nothing entered for ActualExpenditure so the 
calculated field is giving #Error result.
I tried several ways to remove this error but cannot.  Two examples are 
shown.

=IIf(IsError([ActualExpenditure]/[Budget]*100),0,[ActualExpenditure]/
[Budget]*100)
=Nz([ActualExpenditure]/[Budget]*100)

How can I remove the #Error