Entering a null value in a field

  • Thread starter Thread starter Vincent
  • Start date Start date
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
 
Vincent,

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

HTH,
Nikos
 
Back
Top