Counting distinct data from a field on a report.

G

Guest

Ok, Ive looked on and off for a answer to this question for the last couple
of days. I have created a report which lists the names and the trades of
workers. In the report footer i want to be able to have a breakdown of each
trade so say 5 workers come up in the report for the inputted time frame. I
want to count how many of each trade
so it semi looks like this in the report.

name surname trade
tim mann painter
stan chip bricklayer

so in the report footer i have a text box and i want it to count how many
painters where in trade on the report... or how many bricklayers were in
trade on the report. Please someone has to know the answer to this one.

Thanks in advance,
Steve
 
G

Guest

Can you do a sub report which uses the same criteria and groups / counts to
give the result you need? Then put that sub report in the report footer HTH

Sheila
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top