14 Replies Latest reply on Sep 29, 2009 12:59 PM by philmodjunk

    Generating and Comparing Month-end Snapshots

    bluebarry

      Title

      Generating and Comparing Month-end Snapshots

      Post

      I'm sure this is dead easy, but here goes...

      I have a database with a small number of records, and I want to be able to record a snapshot of the content of a few fields on each record as they appear at month-end, and compare them on a month-over-month and quarterly basis.

      Can someone suggest the most efficient way of doing this?