You can "flag" each record with a 1 or 0 then sum on that to flag the client. You also mention you need to include records with no achievements. If you are joining tables make sure you use a left join to address that (unless you wanted them excluded to start with).
Group on your client record and place this formula in the details.
if {table.category ID} = 1 and {table.date} in #05/01/2009# to < #05/31/2009# then 1 else 0
Create a SUM on formula.
Place it in the client header.
you can either suppress all the clients with a SUM>0 or exclude them in the select expert group selection critieria (or the inverse if you want only clinets that had a record in that time period).
Edited by DBlank - 18 May 2009 at 6:50am
IP Logged
