Function

A

Andre Adams

Hello,

There is a funcition in excel that allows you to say, "If there is an value
in this cell and the value = 0 then input XYZ in this cell." Is there
something like that in Access?

Andre Adams
 
J

John W. Vinson

Hello,

There is a funcition in excel that allows you to say, "If there is an value
in this cell and the value = 0 then input XYZ in this cell." Is there
something like that in Access?

Andre Adams
Click to expand...

Please explain what you are trying to accomplish in real-life terms.

Excel is a spreadsheet; it has cells. Access is an environment for
developing relational databases; it DOESN'T have cells. Even though a
table datasheet looks like a spreadsheet *it isn't one*.

In particular, an Access table field must have a designated data type.
If it's a Number field then it *cannot* contain a text string; if it's
a Text data type, then putting 0 in it puts in the text string "0",
not a numeric value (though it can be converted to numeric if needed).


John W. Vinson [MVP]
 
Top