COPYING VALUES IN A TABLE DATASHEET VIEW

[Carol]

Hi. I'm almost embarrassed to ask such an elementary question - but I can't
seem to figure this out.

I have a table opened in Datasheet view. I need to COPY a value that is in
record 1 in the "Account Type" column into all the remaining records. This
value only appears one time in this column and I need to copy it down to the
rest of the records. Simple right? Just copy it and paste it down to all
remaining records - like Excel... but it doesn't work. I can only paste it
in one record at a time. Am I missing something?
I copy the value that is in record one.. then highlight the remaining
records in that column and try to paste. It only pastes in record 2.

Thanks and I apologize if there's an easy solution that I'm missing.

 

[Gary Walter]

Hi. I'm almost embarrassed to ask such an elementary question - but I
can't
seem to figure this out.

I have a table opened in Datasheet view. I need to COPY a value that is
in
record 1 in the "Account Type" column into all the remaining records.
This
value only appears one time in this column and I need to copy it down to
the
rest of the records. Simple right? Just copy it and paste it down to
all
remaining records - like Excel... but it doesn't work. I can only paste
it
in one record at a time. Am I missing something?
I copy the value that is in record one.. then highlight the remaining
records in that column and try to paste. It only pastes in record 2.

Thanks and I apologize if there's an easy solution that I'm missing.

May I suggest using a query instead?

Start a new query.

Add your table.

Double-click on the field.

In top menu, change to Update query.

In Update To row of grid for the column
of your field, type in that value.

Click on red exclamation mark to run.

Close query w/o saving.

Done.

 

[Carol]

Thank you Gary! I forgot to mention that all the records are not blank, so
I would only need to copy/past the values into those records that were blank.
However, your solution worked - I just added the criteria to update only
records that contained a null value.

Thanks again.