We are needing 10% audited right now.
Here is the query I have so far:
SELECT Call.Call_Num, Org.OrgName, Call.ClosedDate
FROM (Call INNER JOIN Org ON Call.Org_ID = Org.Org_ID) INNER JOIN zSysUser ON Call.ClosedBy = zSysUser.UserName
WHERE (((Call.ClosedDate)>=#2/18/2004# And (Call.ClosedDate)<=#2/19/2004#) AND ((zSysUser.Queue1) Like ".FLS*" And (zSysUser.Queue1) Not Like "*HW") AND ((Call.Project)=0) AND ((Call.IsClosed)=-1));
Let me know.