Updating an accessDB without overwriting the previous record

[solskjaer]

Hi all,
i hv created an asp file, it is connected to an access DB.
what i am looking to do & have achieved:

name emp_id amount date
a 1 1 1/4/07
b 2 2 1/4/07
c 4 1 1/4/07

now what i need is that for the next date i.e. 2/4/07

name emp_id amount date
a 1 1 2/4/07
c 4 2 2/4/07
b 2 1 2/4/07

so basically what happens is that for each new date the previous day records are overwritten
but they should not be lost, since if a month report has to be generated then all the data as of 1/4/07 to 30/4/07 needs to be there and also in the event of records needed for 1/4/07 to 30/6/07 the data should be present.

[Rabbit]

Hi all,
i hv created an asp file, it is connected to an access DB.
what i am looking to do & have achieved:

name emp_id amount date
a 1 1 1/4/07
b 2 2 1/4/07
c 4 1 1/4/07

now what i need is that for the next date i.e. 2/4/07

name emp_id amount date
a 1 1 2/4/07
c 4 2 2/4/07
b 2 1 2/4/07

so basically what happens is that for each new date the previous day records are overwritten
but they should not be lost, since if a month report has to be generated then all the data as of 1/4/07 to 30/4/07 needs to be there and also in the event of records needed for 1/4/07 to 30/6/07 the data should be present.

You can't overwrite a record and still keep it's old value, that's contradictory. What you do if you want to track things over time is to create new records.

[NeoPa]

If you include the date in the record itself (as a field), then you have no need to delete any data or records. Simply select the ones you're interested in at any one time by the date.