How to archive data

[chriswrcg]

I was wondering how to archive data in the same spreadsheet. I know that this might seam like a stupid question but bear with me.
I track employees in a ware house. what jobs they do, how many moves they make, how many pieces the carry in a day. this is all great and easy to build in access but the next day when I enter the data the old data is replaced. (I know...Duh!)


I know the simple answer is to just save a new copy each day but I am going to have to figure out how to create a report for the week and month that will have to draw on the archived data. I know from my excel experience that it is easier to point to an archive worksheet in the workbook rather that a folder on your computer or network and each days individual spreadsheet or database.
I do realize i might be over thinking this as I am so new to access but what advice can anyone give me? What is the best way to handle this?

[pbaldy]

In my mind, you shouldn't be "archiving" anything. Your data should include a date. When you add new records, you include the date (and time?). That lets you run reports for any date range.

[chriswrcg]

I told you I was over thinking it. Access keeps the Old dates data when you add the new date?

[pbaldy]

Well, you'd want to enter a new record with the new date. If you overwrite an existing record, it won't be saved anywhere.

[chriswrcg]

How do I ensure I am creating a new record each day when I put in the new data in my form?

[pbaldy]

If the form is only to add new records, set its Data Entry property to Yes.

[chriswrcg]

you know what my next question is, How?

[pbaldy]

It's a property of the form. It can also be controlled with the arguments of OpenForm.

[chriswrcg]

I have no idea how to change the property of the form. Can you tell me how to do it please?

[chriswrcg]

Never mind, I figured it out