Fairly new to Access so I guess the answer to this is simple and probably well known but I can't see it - help appreciated please.
1) Report is based on duplicates query which searches for records of similar type (region/location) and displays detail of all other information associated with each location. (Threshold of number records to look for is set via form to limit small counts).
2) I count and display the number of records for each location in the group header of the report by =count(*)
3) I now need to sort the records within the overall report in descending order of number of records for each location. i.e. based on the "count" result I guess, but can't see where(or how)to do it.
Many thanks
1) Report is based on duplicates query which searches for records of similar type (region/location) and displays detail of all other information associated with each location. (Threshold of number records to look for is set via form to limit small counts).
2) I count and display the number of records for each location in the group header of the report by =count(*)
3) I now need to sort the records within the overall report in descending order of number of records for each location. i.e. based on the "count" result I guess, but can't see where(or how)to do it.
Many thanks
