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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting Null fields 3
Need null values for several fields in db 1
Adding the value of two fields when value is null 4
Null or NOT in another table 4
Joning on null value 3
Suppress comma in calculated field given Null 1
update two fields at once 1
Null value question 2

Back
Top