Null Fields to 0 or ...

  • Thread starter Thread starter Dreamer
  • Start date Start date
D

Dreamer

Hello group!

I need to turn null fields in "0" or "a space" (I dont know) since, when
arming the relations and making a Queries, do not show me the totality of
the records that there are in the main table...

There is some FAST and SIMPLE method so that a person with few knowledge of
Access can make this task?

Sorry for my english!!!

Thanks a lot for all!!

Dreamer.
 
Hi Dreamer,

you can use NZ function to convert null values into 0, " ", or any other
value you may want.
 
If you are saying that your queries are not finding records, perhaps your
criterion needs to be:

Is Null or ""

(the zero-length string can look like a null).

Or if you are actually trying to produce a query result with a "0", Luiz'
response offers the Nz() function.

Or are you trying to modify the data stored? Recall that statistically, a
null means no answer was given to the item, where a zero could mean that the
answer was "none." These are not equal.
 
Back
Top