Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 13 Oct 2015 at 5:48am
do s group summary as a distinct count of the union number field at eh Employee# group
this should give a value where 1 means staff with only one union # and anything > 1 is the records you seek.
You can then add a group filter on the report using that summary result.
something like
DISTINCTCOUNT(unionid,employeeid)>1
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum