SELECT EmployeeNum_1.EmployeeID, EmployeeNum_1.TempId, EmployeeNum_1.Unldr_#, EmployeeNum_1.Last_name, EmployeeNum_1.First_name, EmployeeNum_1.Active, EmployeeNum_1.PayRateHourly, EmployeeNum_1.PayRatePercentage, EmployeeNum_1.SpecialPay, EmployeeNum_1.HolidayPay, EmployeeNum_1.SalaryPay, WorkDays_1.Workdate, WorkdayPunches_1.Punchkey AS PunchKey, WorkdayPunches_1.PunchTime, WorkdayPunches_1.Action, WorkdayPunches_1.Note, WorkdayPunches_1.Deleted AS PunchDelete, WorkDays_1.deleted AS WorkDayDelete, EmployeeNum_1.JobTitle FROM EmployeeNum AS EmployeeNum_1 INNER JOIN WorkDays AS WorkDays_1 ON EmployeeNum_1.Unldr_# = WorkDays_1.Unldr_# INNER JOIN WorkdayPunches AS WorkdayPunches_1 ON WorkDays_1.UID = WorkdayPunches_1.Punchkey WHERE (EmployeeNum_1.Active = 1) AND (DATEPART(wk, WorkdayPunches_1.PunchTime) = DATEPART(wk, @Date)) ORDER BY WorkDays_1.Workdate, WorkdayPunches_1.PunchTime
|Crystal Reports 11 Ignoring Parameters||3||68|
|Help with a Crystal Report Formula||8||43|
|Crystal Formula to "conditionally count/sum"||3||40|
|How do I print a text string based on a field value #1 set to True or print the contents of another field #2 if field #1 is False or Null?||3||18|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
28 Experts available now in Live!