Count items in report

[FJM]

I have the following Count in a report
=" = " & Count(*) & " " & IIf(Count(*)=1,"item","items") & ""
When the report runs, it includes items where the quantity is equal to 1.
I don't want to see these.


Does anyone know how I can restrict the report to only include all items where the count >1

[Gicu]

Do it in the query on which the report is based.

Cheers,
Vlad

[FJM]

I do not know how to do this.......
Can you explain how I transfer the Count details shown on the report into the query

[Gicu]

Can you show us what you want?

[FJM]

This is the report I have.
At the moment, most of the "Total number of entries" count are 1.
I want to get rid of these. Then, with the records that are left, I want to sort by highest count to lowest count.

This is the query which runs the report

[Gicu]

Create a new query called qryPartsOverOne or something with the following SQL :

SELECT NCRFORM.NCRNO, Count(NCRFORM.CREPARTNO) AS CountOfCREPARTNO
FROM NCRFORM
GROUP BY NCRFORM.NCRNO
HAVING (((Count(NCRFORM.CREPARTNO))>1))
ORDER BY Count(NCRFORM.CREPARTNO) DESC;




Now link it via the NCRNO field to your original query and it will eliminate the parts that have a count of 1 and sort them descending as requested.

Cheers,
Vlad