Hello,
i want to create a history of my Purchase Orders, however the information on
this report comes from two tables and one of these tables is just a Excel
Linked table that changes everyday. does anyone has any idea on how can i do
this. thanks ahead.
In order to keep a history of data, it must be stored somewhere under
your control. It sounds like the Excel data can change outside your
control.
If the rows in Excel have unique key values (like PO number), then you
could use queries to update existing POs and append new POs into an
Access table in a daily process. If a PO disappears from the Excel
sheet, the latest information would remain in the Access table, thus
preserving some kind of history.
If you mean that you need to record a history of all *changes* to each
PO, that's a tougher problem. In that case you would need to have
date & time stamped records in a table, and add to it every time a PO
changes. This is more difficult to implement.
Without knowing more about what you need to do, this is all I can
suggest to get you started.
Armen Stein
Microsoft Access MVP
www.JStreetTech.com
