I have a query with client name, their open date and closed date. I want to create a field that calculate the date difference between the current open date and the previous closed date. for example:
clientName Opendate closeddate diffe
a1 1/1/07 12/1/07
a1 2/1/08 60
if the client came in for the first time the field stay blank.
Thanks in advance.
