snapshot of client at start vs at end

[polymatt]

I'm working on a database of client info.

The table houses info. on individual clients over the course of our serving them (name, marketing info. [youth, senior, etc.], which services they purchased, % satisfaction with service, etc.)

What my boss wants is to be able to compare a snapshot of when they started working with us to one when they stopped (or at a later time) (e.g. what % are they satisfied with us at start vs. at end).

Is there a good method for this for individuals (like, not just backing-up whole tables & comparing them later)? & are their calculations that can measure the delta or change between two of the same record & produce a result? Like, they went from only using X service to using X & Y services, they became home owners, etc.?

My knowledge of Access is limited, & I apologize if my dilemma has an easy solution. I know that Access is meant for this kind of thing; I'm just trying to set it up in the smartest & most responsible way I can.

Thanks.

 

[Mihail]

Access, as well as ALL other programming environments, can do (calculate) only and ONLY you can manually calculate. The main (and single) difference is the speed.
So, first step, and the most difficult, is to define the algorithm to use in order to calculate what you need.