Recent content by Bonnie Haring

:confused:I work for an insurance company. Each of our accounts/policies can have several actions throughout the year. Each action has a date as to when that action occured. My query currently lists each action as a seperate line so one account/policy could have up to five lines. Each line...

My query has a field which holds event codes. Another field holds the dates these events happened. I am asked to calculate how many days have passed from the first event to the second and then from the second to the third and so forth. Not every account will have the same events. What is the...