Populating more than one cell in Access 2000 at once. 1

[DrDan1]

Hi.

If I had a column in Excel where each cell I can simply select the column or the cells I want populated and paste them. How can I do that in Access. I have an excess of 400,000 records. I ran a query and out of those I have about 2000 records which need populating in a single column. Just the same small number for each row. Is there a way I can do this without first copying the number and then pushing "Ctrl+V then Down" 2000 times?

Thanks a bunch. ----------------------------------------
Knowing is not enough, we must apply. Willing is not enough, we must do.
--So said the ever wise Bruce Lee
Memorize and live by it!

 

[Frink]

Hallo,

The way to do this in Access is to use an Update Query.

- Frink

 

[DrDan1]

Thanks. I always seem to miss the simple stuff. ----------------------------------------
Knowing is not enough, we must apply. Willing is not enough, we must do.
--So said the ever wise Bruce Lee
Memorize and live by it!