Calculate with IIf [columnA] + [columnB] IIf ColumnB is a number and if "Free" than treat like 0

[Arnold]

Hi


I have 2 columns
A- Price
B- Shipping

ColumnB can also have the value of "Free" which can't be added.

How can I write the total Column to query the total for columnA and B and to treat "Free" like a 0?

[Dal Jeanis]

For one thing, you can use the IsNumeric function. http://www.techonthenet.com/access/f.../isnumeric.php

If either field can be nulls, then you might want to use NZ as well.

[June7]

Mixing data types in one field is problematic. Why do this? Make it a number field. Enter 0 (can be default) or leave it Null.

To calculate a Total column:

[Price] + IIf([Shipping]="Free", 0, [Shipping])