I have no idea how to write a query to get this. Imagine a Table with records like this:
ContNum, Name, Semester, DateCreated
34, Mary , Spring, 3/1/ 2017
34, Mary, Fall, 10/1/2016
45, Jon, Winter, 1/5/2017
45, Jon, Spring , 3/15/17
45, Jon, Fall, 10/2/2016
I want to get back one line per unique ContactNum, with the count of how many there are for each ContactNum and the date of the first Date created. A result like this:
ContactNum, Name, Number of Semesters, Date of first Created
34, Mary, 2, 10/1/2016
45, Jon, 3, 10/2/2016
Is that even possible?
Appreciate ideas please!, Ultimately I would like a view with the result.
thank you,
Eva