Hi Kirk,
I would try to do something similar to
Re: Help creating Summary Query Thread #
712884 Message #
713011.
>I am trying to get the query below to group on procid, so that the numberdone represents how many where done. Currently, it lists each one out. I believe this is because I have as the third group by item the meetingnumber (which represents the basic case). But if I remove the meetingnumber from the group by clause, I get an error saying that the column meetingnumber is invalid in the select list, yata yata yata.
>
>I have tried putting count(meetingnumber) in the primary select statement but that didn't work either.
>
< snip >
--sb--