L
Lost
I am new to using access, I know how to do this in Excel, but do not know if
there is a way to do it in access.
I need to populate a field based upon two other columns in a table and do
not know how to go about making it automated.
What I need is for "field3" to return a "1" if "field1" is null and for
"field3" to return a "2" if "field2" is null and for "field3" to return a "0"
if both "field1" and "field2" are null....
there is a way to do it in access.
I need to populate a field based upon two other columns in a table and do
not know how to go about making it automated.
What I need is for "field3" to return a "1" if "field1" is null and for
"field3" to return a "2" if "field2" is null and for "field3" to return a "0"
if both "field1" and "field2" are null....