list direct debit info if entered > 12 times

  • Thread starter Thread starter Robin Brunton
  • Start date Start date
R

Robin Brunton

Access/Excel query

I have a spread sheet that list monthly direct debits per person. The
spreadsheet is cumulative, so the same name will appear more than once.

My query is, is it possible to create a report or list that will flag up a
name if it has been entered more than 12 times.
 
Try a Summary query with the count function. Create a
query than click on the name field in Design View and
select Totals this will change it to group by. Select
another field (say the phone number) and select count
under totals. You will get a total number of records by
name. You can set the Query condition for the count field
to be >12

Kevin
 
Back
Top