Ignore duplicated records in a report

ddrumm

Registered User.
Local time
Today, 01:17
Joined
May 19, 2009
Messages
10
Hi
Ive the below in a textbox on a report, its running fine, but im trying to add to it.
Im trying to get it to count just one IN per day, if theres two or three IN's i want it to ignore it

=Sum(IIf([Emp_Name]="INl",0,1))

Thanks
 

Users who are viewing this thread

Back
Top Bottom