Windsor302
Registered User.
- Local time
- Today, 14:44
- Joined
- Jul 13, 2011
- Messages
- 56
Hey guys, here is the code i am working with so far:
SELECT [TRO SCOPE 3].WELDER_ID, Count([TRO SCOPE 3].WELD_DATE) AS WeldsCompletedtoDate, Count([TRO SCOPE 3].RT_DATE) AS RTCompletedtoDate
FROM [TRO SCOPE 3]
GROUP BY [TRO SCOPE 3].WELDER_ID
HAVING ((([TRO SCOPE 3].WELDER_ID) Is Not Null) AND ((Count([TRO SCOPE 3].WELD_DATE)) Is Not Null) AND ((Count([TRO SCOPE 3].RT_DATE)) Is Not Null))
I get a total of welds completed per welder. now from the same table as the other info there is a column with [NDE_CATEGORY], i want to count original and rework from the column only. I have been pleying around with it but with no luck, let me know what you think. Thanks.
SELECT [TRO SCOPE 3].WELDER_ID, Count([TRO SCOPE 3].WELD_DATE) AS WeldsCompletedtoDate, Count([TRO SCOPE 3].RT_DATE) AS RTCompletedtoDate
FROM [TRO SCOPE 3]
GROUP BY [TRO SCOPE 3].WELDER_ID
HAVING ((([TRO SCOPE 3].WELDER_ID) Is Not Null) AND ((Count([TRO SCOPE 3].WELD_DATE)) Is Not Null) AND ((Count([TRO SCOPE 3].RT_DATE)) Is Not Null))
I get a total of welds completed per welder. now from the same table as the other info there is a column with [NDE_CATEGORY], i want to count original and rework from the column only. I have been pleying around with it but with no luck, let me know what you think. Thanks.
