Hi All,
I’m trying to figure out how to get a count of groups in a recordset in an Access 2000 report. For example, I’ve got a list of employees that work on different jobs with multiple income details on each job.
When I sort by 1) employee, 2) job, 3) details, how can I count how many different JOBS the employee worked on? I don’t want a count of the number of detail records in each group.
No matter how I seem to set up various count() controls, it always seems to count the detail records themselves, not the # of jobs the fellow worked on this payroll.
I mainly need this in the context of an Access report. Should I achieve the count from SQL or is there a way to get the headers/footers to track a count?
I’ve dug through all my books and sample databases and am now wondering if I’m just missing something simple, or if that really is something of a trick…
Perhaps I need to use VBA?
Thanks for any ideas or suggestions,
Howard Henderson
