Built In Functions ? Null ?

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

I've added a currency field, [ExtraCharge?], to an existing table. Most of
the records have nothing entered in the [ExtraCharge?] field. When I try to
use this field in a report control with an expression, (ex: =[SubTotal] +
[ExtraCharge?] ), the control shows the results only if the [ExtraCharge?]
field in not null.

For example:
Say [SubTotal] was $10. [ExtraCharge?] is null. The displayed result is
blank.
However if 'SubTotal' is $10 and [ExtraCharge?] is $2., then the displayed
result is $12.

Is there a help file within AccessXP which tells how the different built in
functions work. So null values will be handled as a $0. value? There is an
extensive list of these functions in the 'expression builder' but I don't
know what they do.

Thanks,
Les
 
Try:

=([SubTotal] + NZ([ExtraCharge?],0) )

Do the same if sub-total can be null also.
 
Thanks Albert,

That did it. How did you find out what the different 'built in functions'
do?

Les
 
Back
Top