Table Data Fill

[Pat Falango]

How can I fill a column down with the same data that's in the same field as
the record above field, even when a filter is applied. I found that I can
use CTRL + APOSTROPHE(') to repeat a value of the previous record, but that
seems to fill only one field at a time.

 

[Rick B]

You can create an update query to update a group of records with a
particular value. Create a select query to find the records you want.
Verify that it pulls up the correct ones, then change it to an update query
and tell it what to place in the appropriate field.

You might also consider setting a default value so that when a record is
first created it can default to a particular value (rather than making the
user copy one).

 

[John Vinson]

How can I fill a column down with the same data that's in the same field as
the record above field, even when a filter is applied. I found that I can
use CTRL + APOSTROPHE(') to repeat a value of the previous record, but that
seems to fill only one field at a time.

You're thinking spreadsheet. Access Tables *are not spreadsheets* and
there is no "record above"! A Table is an unordered "heap" of records,
and in a normalized table you would not have values in one record
dependent on values in another record.

What is the nature of this data, and what are you trying to
accomplish?

John W. Vinson[MVP]

 

[Pat Falango]

You're thinking spreadsheet. Access Tables *are not spreadsheets* and
there is no "record above"! A Table is an unordered "heap" of records,
and in a normalized table you would not have values in one record
dependent on values in another record.
Oh.


What is the nature of this data, and what are you trying to
accomplish?

It's manually entered text and or numbers into fields that had been
null. I want to be able to copy a field into multple other fields with 2 or
3 key strokes or clicks, like I can do in a spreadsheet. I don't have
design priviledges for the table, I am just trying to enter missing data.

 

[John Vinson]

It's manually entered text and or numbers into fields that had been
null. I want to be able to copy a field into multple other fields with 2 or
3 key strokes or clicks, like I can do in a spreadsheet. I don't have
design priviledges for the table, I am just trying to enter missing data.

An Update query will let you enter data into multiple records in one
shot. Just be sure you have the correct criteria - IS NULL as a
criterion on the field you're updating (to prevent overwriting
existing data), and whatever other criteria would let you select the
records to be updated.

You can't select a range of cells and paste a single value into all of
them, though.

John W. Vinson[MVP]