database to calculate period clients are with us

[Guest]

I will like to design a database that would keep details of old and new
clients but also calculate automaticly if possible the period of time each
client has been with us i.e moved in on ---------- left on or current
date........

 

[Rick B]

Ok.

What is your qestion?

To calculate duration, use DateDiff. You could use an IF statement to
apply the current date if the left date is blank.

Rick B