I have a table in which lies a list of tasks. i need to produce a layout that will list found records, and show a "quantity", a number of times it occurs in the found set. I additionally only need the item to be shown once, and not for each occurrence of it.
Please can you advise. If I haven't worded it very well I apologise, and please ask any questions that would help.