How can I fill the empty cells in a table with a number , for example "-999" or text, such as" na".

You can use update query to fill empty cells

Why do you need to fill the records in the table?
If required you can usually deal with these null values when generating a report from the data.

As Mr. Khawar suggests...
Fill them with an Update Query and the where Condition should be "=Null"

Example,,,,

UPDATE Table1 SET Table1.Numb = "A", Table1.[NAMES] = "A", Table1.SAL = "A", Table1.NOTES = "A"
WHERE (((Table1.Numb)=Null) AND ((Table1.NAMES)=Null) AND ((Table1.SAL)=Null) AND ((Table1.NOTES)=Null));

As Mr. Khawar suggests...
Fill them with an Update Query and the where Condition should be "=Null"


The condition to find empty records in a field is "Is Null" (without the quotes). Access does not work with either = or <> as a Null comparator.

"=Null" certainly does not return records with the Null in that field.

If I remember correctly Acess 2003 returns an error. However Access 2007 accepts =Null (even capitalises the n) although it does not work to find Nulls.
Perhaps it does now mean something. Anyone know? Couldn't find any reference online other than sites saying it doesn't work.

Perhaps it does now mean something. Anyone know? Couldn't find any reference online other than sites saying it doesn't work.

No, you are right, GalaxiomAtHome. The correct syntax is:

WHERE [MyField] Is Null