Reports or Queries

  • Thread starter Thread starter drmstuff
  • Start date Start date
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.
 
Create a sum/group query
as criteria of the column that you want greater than a certain number
place > that number

Ron
 
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).
 
Back
Top