Show only groups having Record Count more than one

[Tejas.T]

I have create a simple report in which I am grouping records by last 2 digits of Either Phone or Phone2 field of my database.
It works fine but I need to display only those records(groups) which has more than one record in it.

Attached is snapshot of report generated. And below is the query I am using as RecordSource of report.

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



Can anybody please suggest me a solution for this?

Thanks,
Tejas

[Tejas.T]

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:

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

[Tejas.T]

Anybody can help me here please?