Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Access - Filling Blanks
I have records that have blanks in one field. I want to put the same value
in all of them. How can I do this? Replace doesn't seem to work for Blank fields wal50 |
#2
|
|||
|
|||
Hi
- select the data range - hit F5, click 'Special' and choose 'blank cells' - enter your value and hit CTRL+ENTER -- Regards Frank Kabel Frankfurt, Germany "wal50" schrieb im Newsbeitrag ... I have records that have blanks in one field. I want to put the same value in all of them. How can I do this? Replace doesn't seem to work for Blank fields wal50 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) | |||
Filling in blanks. | Excel Worksheet Functions |