copy on cell to another

[Sean]

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 am just learning access so please be specific in your
directions,

Thanks for the help

 

[TC]

Sean, your question indicates that the table is not designed correctly. If,
for some set of records, certain fields will always have the same value,
then, those fields should not be in those records, in that table. They
should be in >one< record in a higher-level, "master" table. In that regard,
designing database tables is totally & completely different to designing a
spreadsheet. Your data sounds like it comes from a spreadsheet.

Perhaps read this:
http://support.microsoft.com/support/kb/articles/Q100139.ASP

HTH,
TC