Okay guys and gals here is a problem that I need help on, I am trying
to develop a report that will display only duplicate values. Here is an
example of the data that I am working with:
DATE CALL ID MEMBERSHIP TYPE TROUBLE
07/18/05 232 123456789 ERS 6
07/18/05 525 123456789 SVC 6
07/18/05 6585 456789123 ERS 7
07/18/05 5114 787941232 ERS 2
07/18/05 6742 336125522 SVC 3
What I want is a report that will display only the following
DATE CALL ID MEMBERSHIP TYPE TROUBLE
07/18/05 232 123456789 ERS 6
07/18/05 525 123456789 SVC 6
So the main point is that any membership that has more than one call in
a day that it would be reported. I have tried a group by on the
membership but I couldn't get it to work. All of the fields are located
within one table. Thanks in advance!