data update by time/date

R

rebecca

Hello-
My need is very specific. I need to store data on a daily basis using the
same name and location, some of the fields will be updated and I need the
updates to be saved via date, with the remaining data unchanged. The problem
I'm running into is that every time I update data I am unable to save the old
data. Is there some way to do this? I'm trying to use a table or form.
 
K

KARL DEWEY

I'm running into is that every time I update data I am unable to save the
old data. Is there some way to do this?
An 'update' is just that - it overwrites old data with new. You probably
need to create new records if you need to retain old data. You can flag old
data by adding a Yes/No field named someting like Old or Acrhive. Then have
criteria in your queries to pull records that are not old.
Explain a little of what you are trying to do with the data and maybe others
can suggest ways to accomplish it.
 
Top