Hello everyone, I have a table that has the following columns; caseno, clientname, server, opendate.
The data consists of all clients and their assignments to a therapist along with the date of the assignment. If a client was ever reassigned to a new therapist then there would be multiple records for that client. What I need to do is to add a column (closedate) to the table and set the column to equal the open date of the previous record if there are multiple records for that client, thus giving me a close date for that record. I need to leave those without multiple records blank. The table is sorted by clientname, opendate asc. Thanks for your help. I miss you all! Ron
