Paste Multiple Cells

[Guest]

I've received a database that contains the land use of municipal parcels.
The first coloumn = Land Use Description
The second coloumn = Land Use Remarks
The third coloumn which I've added = Land Use

They've given us a standardised land use table to go through the database
and add a standardised Land Use for each parcel

example:
Land Use Remarks Land Use Description Land Use
Residential Dwelling House - Detached Dwelling House

There are 30 000 records and the majority are going to be Dwellin House. I
would like to select the cells in the coloumn Land Use which I created which
are Residential - Dwelling House - Detached and paste Dwelling House instead
of having to type each record or to create a lookup table, but selecting more
that one cell and pasting only pastes the first selected cell.

Any assitance will be greatly appreciated.

Peter Wilson

 

[John Vinson]

There are 30 000 records and the majority are going to be Dwellin House. I
would like to select the cells in the coloumn Land Use which I created which
are Residential - Dwelling House - Detached and paste Dwelling House instead
of having to type each record or to create a lookup table, but selecting more
that one cell and pasting only pastes the first selected cell.

Any assitance will be greatly appreciated.

Use an Update query instead. Copy and paste is fine for spreadsheets,
but an Access table isn't a spreadsheet.

I'd suggest creating a Query based on your table. Put a criterion of

IS NULL

on the [Land Use] field, and - to maybe save yourself some work -

LIKE "*Dwelling*"

on the [Land Use Description] field. Click the datasheet icon at the
left end of the toolbar to see which records (and how many) this
returns.

If it's the records that you want to edit, change the query to an
Update query (using the Query menu option or the query type icon in
the toolbar); on the Update To line under Land Use put

"Dwelling House"

Run the query by clicking the ! icon and it will do all of them in one
swell foop.

You can then create a new query with the criterion IS NULL on [Land
Use] but no other criteria; this will let you look at the properties
which are not currently classified as dwellings, so you can update
*them* to something appropriate. I'd prefer this to loading data that
you know to be incorrect (making hospitals, gas stations, and churches
all into Dwelling Houses when they *aren't*).

John W. Vinson[MVP]