Entering a null value in a field

V

Vincent

Dear all,

I am experiencing some trouble trying to input a null value in a
field, when a condition in another field occurs, by means of a query.
I am able to enter a space (" ") but, how to I represent a null
value?. I do not think that a function returning a null value exists
"null()". Could anybody help?

Access 2000 on Windows 2000

Regards
 
N

Nikos Yannacopoulos

Vincent,

Just the word Null (no quotes or anything), or "" with no space in between.

HTH,
Nikos
 
Top