Re: Obtaining the first or second instance of an event

Hi David, David Scott wrote: I am looking at data from a telephone call centre. I have a table giving data on calls made including time and date with the name CallDateTime. Each call has a number, CallId and each customer has a number CustomerNo. Each row represents a different call. I wou

Obtaining the first or second instance of an event

I am looking at data from a telephone call centre. I have a table giving data on calls made including time and date with the name CallDateTime. Each call has a number, CallId and each customer has a number CustomerNo. Each row represents a different call. I would like to create a column whic