S
Sheri Emery
Hi,
I want to append old records to a "historical table", so
I've created a Query and used the Append option. I'm
running into a bit of a snag though - I want to keep the
most recent data for each client in the current table, but
I'm not sure how to specify this in the query criteria.
Basically, whenever there is an update, I want the old
records for that client in the historical table and the
updated data to appear in the current table. I want to
use this option so that my reports grab the most current
data, but we also have a historical record of when changes
occurred. I really appreciate any assistance you can
provide.
Thanks,
Sheri
I want to append old records to a "historical table", so
I've created a Query and used the Append option. I'm
running into a bit of a snag though - I want to keep the
most recent data for each client in the current table, but
I'm not sure how to specify this in the query criteria.
Basically, whenever there is an update, I want the old
records for that client in the historical table and the
updated data to appear in the current table. I want to
use this option so that my reports grab the most current
data, but we also have a historical record of when changes
occurred. I really appreciate any assistance you can
provide.
Thanks,
Sheri