I have created a simple report where I group records either by Phone or Phone2 field.It is working fine but I need to show only those groups having record count more than 1.
Below is the snap shot of my report.
So here I want to show up only the 2nd group, and not the others because they have only 1 record in it.
Below is the query I am using as record source:
Code:
SELECT S.FirstName, S.LastName, CD.Phone, CD.Phone2, Right(CD.Phone,4) AS GroupingField
FROM Student AS S, ContactDetails AS CD WHERE S.Roll=CD.Roll;
UNION ALL
SELECT S.FirstName, S.LastName, CD.Phone, CD.Phone2, Right(CD.Phone2,4) AS GroupingField
FROM Student AS S, ContactDetails AS CD WHERE S.Roll=CD.Roll;
Database file can be downloaded from here:https://drive.google.com/file/d/0B7g...ew?usp=sharing