SELECT qryProject.[TaskOrder], [OBS Master].OBS, [Lname] & ', ' & [Fname] AS Name, [OBS Master].Fname, [OBS Master].Lname, qryProject.[ChargeNumber], qryProject.Posted AS WeekEnding, qryProject.Workhours AS RegularHours, [FY11B]+[FY11OH] AS FY11Rate, [RegularHours]*[FY11Rate] AS RegularPay, qryProject.Overtime AS OvertimeHours, [OT11B]+[OT11OH] AS FY11otRate, [OvertimeHours]*[FY11otRate] AS OvertimePay, [OBS Master].ODC3 AS FY11odcRate, [OBS Master].Fee2 AS FY11FeeRate,[RegularPay]+[OvertimePay] AS TotalPay, [OBS Master].FY11B, [OBS Master].FY11OH, [OBS Master].OT11B, [OBS Master].OT11OH, project.Comments, project.locked, qryProject.source, [OBS Master].[Company ] FROM (Period INNER JOIN qryProject ON Period.[Week Ending] = qryProject.Posted) INNER JOIN [OBS Master] ON qryProject.OBS = [OBS Master].OBS WHERE qryProject.locked = False AND qryProject.source Like 'a' AND [Week Ending] = #4/22/2011# AND Company = 'EC' ORDER BY TaskOrder
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.