Changing a " " value to a blank - !! 1

[russanalyst]

Hi. This might sound stupid but it is a real issue for us.
In our datafile some fields' values were updated to " " . A government entity wants the value to be blank, instead.

How do I change this?

Likewise, there are some instances where the reverse is true.

How do I change those?

Russ

 

[genomon]

Double quotes enclosing a single space IS a blank. An empty string would be double quotes with nothing in between. Both of these are different than a null. Sounds like you need to meet with the stakeholders and find out exactly what THEY think "blank" means....

Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.

 

[russanalyst]

Hi.
Thanks for the response.
Unfortunately, the chain of command does not allow me direct access to the group that set the specs.

One final question for you is what makes a NULL ?

Russ

 

[genomon]

Actually I mis-spoke. Double quotes enclosing a single space is a space, which some consider a "blank". A null is the absence of anything.
There is a decent discussion here:

http://www.thescripts.com/forum/thread202264.html

Also MSKB, Google, and the FAQs here are an excellent source of information (as is the help feature in Access).

Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.

 

[russanalyst]

Thanks so much!

Russ