report - display only groups with more than one detail record

Question

rptConflicts based on qryConflicts with fields partnumber, machinenumber, notes

Group header on partnumber

I would like to display only those partnumbers that have two or more records (machinenumber, notes).

I tried adding =Count(partnumber) > 1 to my underlying query but threw an error.

Any suggestions?

---

MS - Teach me to fish

Answer 1

Hi. Please post your SQL statement, so we can see why you got an error. Thanks.

Answer 2

Hi lismeta,

For a filter on a group by query, you could try something like below:

SELECT Name,Count(*) 
FROM FilterTable
Group by Name
having count(*)>1

If it did not work, as the reply from DB, it would be helpful if you could share us your query and simple data.

Best Regards,

Edward

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.