Null Value is NOT Null????

[nyucknyucknyuck]

I have a field that APPEARS to be null, but I cannot seem to filter whatever it really is.

I've tried filter for spaces, and is null, but nothing comes up. How to I get a blank field to be null if I don't know what to find in order to replace.

I am trying to replace all blank fields with "Admin Assitant" but the query says there are no fields that are null even though HUNDREDS of the fields APPEAR to be empty.

Again, the "space" is not a space or a null value...

I'm stumped.

 

[fneily]

Are you testing one field or many? Are you using AND instead of OR?
Can you post your SQL?

But a bigger question:
You want to replace alot of blank cells with "Admin Assitant". In the first place, why do you have alot of blank cells which will be alot of "Admin Assitant"? Sounds like your table isn't normalized. Can you post your table structure: eg.
tblTableName
EmployeeID Primary Key
FirstName
LastName
etc.

You may need to redesign.

 

[traingamer]

An empty string "" is neither null nor is it a space. Check for that as well.

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[traingamer]

Or select the records that have a len([field]) = 0.

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[PHV]

UPDATE yourTable
SET yourField = "Admin Assitant"
WHERE Trim(yourField & "") = ""

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886