Access and Blanks

[Johnny]

I am starting a small program using Access and would appreciated a bit of help with the following;

In Queries I have built a short Expr1 as follows:

Expr1:([FrameLgt]>=3.2,[FrameLgt]*[SteelRate])

Now if the Value is 3.2 or above the Expr1 returns a result but if the value is below 3.2 the Expr1 returns a Blank.

How do I avoid getting a Blank?

Regards

John

[akhenaton42]

use IIF statement -

Expr1:IIF([FrameLgt]>=3.2,[FrameLgt]*[SteelRate],[write here whatever you want returned])

I am starting a small program using Access and would appreciated a bit of help with the following;

In Queries I have built a short Expr1 as follows:

Expr1:([FrameLgt]>=3.2,[FrameLgt]*[SteelRate])

Now if the Value is 3.2 or above the Expr1 returns a result but if the value is below 3.2 the Expr1 returns a Blank.

How do I avoid getting a Blank?

Regards

John