TRANSFORM Sum(LABORDFILE.[Expended Hrs]) AS [SumOfExpended Hrs] |
|
|
|
|
|
|
|
|
|
SELECT JOBORD.COSTFY, JOBORD.TOPD, JOBORD.[JO#], JOBORD.JOTITLE, JOBORD.[KE#], JOBORD.KETITLE, JOBORD.Issue, Sum(LABORDFILE.[Expended Hrs]) AS [Total Of Expended Hrs] |
FROM JOBORD LEFT JOIN LABORDFILE ON (JOBORD.[JO#] = LABORDFILE.[JO#]) AND (JOBORD.TOPD = LABORDFILE.TOPD) |
|
|
|
|
|
|
GROUP BY JOBORD.COSTFY, JOBORD.TOPD, JOBORD.[JO#], JOBORD.JOTITLE, JOBORD.[KE#], JOBORD.KETITLE, JOBORD.Issue |
|
|
|
|
|
|
PIVOT "Exp " & Format([Trans date],"mmmm") In ("Exp March","Exp
April");
Alax: It worked perfectly. One question if may. If I have the fiscal year in the end result would I need to Format the "Exp " to 3-19 or FY 3-19. Appreciate you opinion.
Again thanks a mil
Gene |
|
|
|
|
|
|
|
|
|