so am working on this report in my db where the foreign key is track how many times too; against another table and its related field. in A queries Total works jus fine but in Reports I get this Control Source function..... =Count(*)
but what am trying to get is the persons with the highest to be on top the Report and least at the bottom, tried group-sort in Reports couldn't figure it out ...... could I also build a Criteria say to excluded persons with a lesser amount so they don't appear in the Report
E.g. I would want persons who foreign key showed up say 3 times or more???? and omit persons with a less Amount.... Right not my db Reports includes everyone and doesn't filter like my Queries