Ho do I copy a value down multiple cells in a column in Access 2007
Posted on 2010-08-27
Hi ...I have created an Access database into which I import new data each month from Excel using the append function.
The database has 15 columns of data. The data that is in one of the columns needs to be changed . I can use the filter funtion to filter the data so that I could copy down the new values, however, it does not seem that Access allows this functionality in the same way you would do it in Excel. i.e. copy the value and then highlight the cells where the value is to be repeated and simply paste (control v).
If any one knows how this is done in Access, I would really appreciate knowing.