Joined: 02 Mar 2011
Online Status: Offline
Posts: 20
Topic: Suppressing employees with two ID's in the report Posted: 04 Mar 2011 at 9:25am
I was wondering if I could get help creating a formula that will suppress/prevent showing employees in the report who were retired and rehired with two employee ID's (i.e. ID given prior to their retiring and a new ID given when they were rehired).
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 07 Mar 2011 at 5:20am
if you group on the SSN and do a distinct count of the empoyee id number under that you can do a group select statement to exclude anything with a count>1 (or suppress as well)
Joined: 02 Mar 2011
Online Status: Offline
Posts: 20
Posted: 07 Mar 2011 at 5:28am
Thanks but could you please tell me how the statement should be written to exclude anything with a count > 1 or to suppress it? Again, thanks for your help
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
IP Logged
