copying one cell to another

[Guest]

In a table, how do a make a cell autopopulate with the
value the is in the cell above it.

For example I have 10 rows of weather data (wind, cloud
cover, temperature, ect). For each record the temperature
will be the same as the previous record so I would like it
to automatically copy the temperature from the previous
record into the temperature of the active record.

I would like to be able to do this in the database view
not in a form.

I know this is not the best design method, I would rather
use subdatabases ect. but that is not how my employer
wants it set up. In addition, I am just learning access
so please be specific in your direction.

Thanks for the help

 

[Tim Ferguson]

In a table, how do a make a cell autopopulate with the
value the is in the cell above it.

Sean (I assume it's you behind the anonymous address): just asking the same
question over again is not going to get you an answer you like better. You
have had sound advice from TC: heed it.

I would like to be able to do this in the database view
not in a form.

Bad. Use the tools that you have appropriately.

I know this is not the best design method,

It's worse than that -- it's a crap method. You would be better off in a
platform that is designed to work the way your employer seems to want, for
example Excel. If you really want to make it hard, why not go the whole way
and use CorelDraw? On the other hand, if it's important to get it to work
right, then you would be best off actually learning how to use Access in an
effective manner.

Hope that helps


Tim F