FrankInBerlin
IS-IT--Management
Hi everybody,
the Problem:
I have customer IDs that can be contated many times.
Each time the customer is contacted the date is entered in the DB.
Now I want to find out how many customers have been contacted x times.
The DB looks like this:
Customer ID Date
1 1.1.2002
1 10.1.2002
2 2.1.2002
3 5.1.2002
.
.
.
The report should look like this:
Number of Customers contacted 1 time: 2
Number of Customers contacted 2 time: 1
.
.
Nummber of Customers contacted x time: x
I guess this is pretty simple, but can't figure it out.
Any Ideas?
Regards,
Frank
the Problem:
I have customer IDs that can be contated many times.
Each time the customer is contacted the date is entered in the DB.
Now I want to find out how many customers have been contacted x times.
The DB looks like this:
Customer ID Date
1 1.1.2002
1 10.1.2002
2 2.1.2002
3 5.1.2002
.
.
.
The report should look like this:
Number of Customers contacted 1 time: 2
Number of Customers contacted 2 time: 1
.
.
Nummber of Customers contacted x time: x
I guess this is pretty simple, but can't figure it out.
Any Ideas?
Regards,
Frank