I have a table that has two columns, terminating lata and number of minutes. Each individual record is a phone call. Each terminating lata appears many times in the table so therefore are many calls that terminate in the same lata. What I need to do is create a new table that has three fields, terminating lata (having each different terminating lata appearing only once), Number of calls for each terminating lata (how many times a terminating lata appeared in the original table), and number of minutes for each terminating lata (sum of the minutes for each different terminating lata from original table). I really don't know how to go about this.
Any ideas would be appreciated.
Thanks,
Ryan