I am creating a calculation in a report which occassionally creates a
negative number. Is there any way I can place a 0 in this field if a
negative number is generated?
--
D Neyman

"D Neyman" wrote

> I am creating a calculation in a report
> which occassionally creates a
> negative number. Is there any way I
> can place a 0 in this field if a
> negative number is generated?

IIF ((yourcalculation)<0, 0, (yourcalculation))

replace both instances of (yourcalculation) with your calculation. If you
are doing your calculation in code, you can simplify just by using an

If ... Then
....
End If

structure instead of the IIF, but the IIF will work in a Control Source
expression, too.

Larry Linson
Microsoft Access MVP

On Tue, 27 Jun 2006 19:09:02 -0700, D Neyman wrote:

> I am creating a calculation in a report which occassionally creates a
> negative number. Is there any way I can place a 0 in this field if a
> negative number is generated?

Use an Unbound control.
Set it's control source to:

=IIf([FieldA]-[FieldB]>0,0,[FieldA]-[FieldB])

Where [FieldA]-[FieldB] represents whatever your actual calculation
is.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

D,
Place this calculation in your field...
=IIF(YourCalculation < 0, 0, YourCalculation)
that should do it.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"D Neyman" <(E-Mail Removed)> wrote in message
news:C9F73AAD-F04F-481D-B2EE-(E-Mail Removed)...
>I am creating a calculation in a report which occassionally creates a
> negative number. Is there any way I can place a 0 in this field if a
> negative number is generated?
> --
> D Neyman