Reports or Queries

D

drmstuff

I've got a report based on a query that will count records within a certain
group(field). I only want to print those records for groups(fields) totaling
count of more that a certain number. Can that be done. If so, how. I can
usually use help and find what I need to answer a question, but not finding
anything.
Thanks in advance.
 
R

Ron2006

Create a sum/group query
as criteria of the column that you want greater than a certain number
place > that number

Ron
 
K

KARL DEWEY

Use a totals query to count records for count of records for groups(fields).
Set criteria for count of more that a certain number.
Open your select query in design view, add the totals query and inner join
on groups(fields).
 
Top