If Value is Empty on the table

If this is a one off action then highlight the table column and press Ctrl+H to bring up the find and replace box.
Leave the "Find What" field blank, put DPS in the "Replace With" field and click "Replace All".

If this is something you need to do frequently then you could add a short macro that can be run to replace blanks with DPS on the selected range.

BSB

Dear BSB,

Can you Help me please with the macro?

thank you in advanced

Try this. You'll need to change the parts in red to the relevant sheet and table name.

Please Login or Register  to view this content.

BSB

Dear,

This not in excel but on ms access! ( see picture)

Dear BSB,

Is working, the question How to run automatic the update query ?

I'm not sure I understand. You'd need some kind of trigger to run run the query and I know nothing about your database to be able to guess what that trigger could be, so you're going to have to provide some detail here.

If you want blanks in that field to always be "DPS" then you can set that as the default value for the field. That way if the user leaves it blank it will default to DPS.

BSB