I am a beginner access user. I have a small database (4500 records) and want
to copy down data in few of the fields (data is same in most of the records)
and then go in and correct the records that are different. Can someone tell
me how to copy down a field

Just a thought, when I have multiple records that all (or almost all) have
the same value for a field I use an update query. Start by creating a select
query, add your table, from the table add the field you want to identify each
record with and then the field you would like to update.

1. Run your query as a select query to make sure you will be updating the
correct records
2. change the query to an update query, in the "Update To" row of the query
type in the value (in the column of the field you want to update) that you
want to update the field to for each individual record
3. Run the query
4. check the results in your table


"jfeiner" wrote:

> I am a beginner access user. I have a small database (4500 records) and want
> to copy down data in few of the fields (data is same in most of the records)
> and then go in and correct the records that are different. Can someone tell
> me how to copy down a field

If you just want to copy data from the cell above, on the keyboard Ctr + '
(apostrophie). You might find it slightly different as I am using an English
keyboard.

"Thorson" wrote:

> Just a thought, when I have multiple records that all (or almost all) have
> the same value for a field I use an update query. Start by creating a select
> query, add your table, from the table add the field you want to identify each
> record with and then the field you would like to update.
>
> 1. Run your query as a select query to make sure you will be updating the
> correct records
> 2. change the query to an update query, in the "Update To" row of the query
> type in the value (in the column of the field you want to update) that you
> want to update the field to for each individual record
> 3. Run the query
> 4. check the results in your table
>
>
> "jfeiner" wrote:
>
> > I am a beginner access user. I have a small database (4500 records) and want
> > to copy down data in few of the fields (data is same in most of the records)
> > and then go in and correct the records that are different. Can someone tell
> > me how to copy down a field