Missing data, but not null...

[nigeve]

Troops, I have a table with approx 2500 records. The StaffID field (a long integer) has lots of blank data. However when I use ‘Is Null’ as a query criteria it only returns 14 rows. They are not zeros (0). Is there anything else can use to search out these rows? Then I can use an IF to replace the value from empty to something meaningful…
Many thanks in advance of suggestions.

 

[plog]

Try a Len() call on it to see what gets returned.

 

[nigeve]

By way of a follow up the original developer has used quite a few listbox look ups on fields. My query was replacing Staff ID’s with Staff names. Personally I don’t like seeing this, I prefer to do my look ups on forms or reports. Using Len() allowed me to spot what was occurring