Please help how to handle this issue on the "Table"
If the State field is empty then it must be replaced with Text = DPS
thank you in advance
Kirana
Please help how to handle this issue on the "Table"
If the State field is empty then it must be replaced with Text = DPS
thank you in advance
Kirana
Last edited by kirana2014; 07-25-2021 at 04:50 AM.
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.
BSBPlease Login or Register to view this content.
With a macro
Please Login or Register to view this content.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
Dear,
This not in excel but on ms access! ( see picture)
Apologies I hadn't noticed it was in the Access forum and the original picture in post #1 didn't make it obvious it was Access.
Create a new query (not using the wizard) and change it to an "Update" query then fill out the grid as below.
Field: State
Table: Table1
Update To: "DPS"
Criteris: Is Null
When you run the query all blanks in the State field will be updated to DPS.
Change Table1 to the real table name.
Worth pointing out that it's worth trying this on a COPY of the database first!
BSB
Last edited by BadlySpelledBuoy; 07-25-2021 at 05:30 AM.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks