database to calculate period clients are with us

  • Thread starter Thread starter Guest
  • Start date Start date
G

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........
 
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
 
Back
Top