J
Joe
Hello,
I am constructing an application to record changes in
some prices of products over time. I have a table with
some products and their corresponding prices. These prices
often keep changing.To keep a track of the changes in the
prices over time, I am constructing an application:
I am creating a table called the archive table and
initially copy all the current records from ym sales table.
Now, I want to create a Macro that periodically compares
the records of the sales table and the archive table.
I want the Macro to create a new record in the archive
table only if finds any field of a particular record in
the sales table was found changed.
SInce I am new to Macros,I would be thankful for any help.
With Regards,
Joe.
I am constructing an application to record changes in
some prices of products over time. I have a table with
some products and their corresponding prices. These prices
often keep changing.To keep a track of the changes in the
prices over time, I am constructing an application:
I am creating a table called the archive table and
initially copy all the current records from ym sales table.
Now, I want to create a Macro that periodically compares
the records of the sales table and the archive table.
I want the Macro to create a new record in the archive
table only if finds any field of a particular record in
the sales table was found changed.
SInce I am new to Macros,I would be thankful for any help.
With Regards,
Joe.