G
Guest
I get this message when I run this query, but I run the same query with dates
between Jan and Feb and it is fine
SELECT dbo_Inspection.Inspection_Id AS [Inspection ID],
dbo_Inspection.PIH_Project AS [PIC Development Number],
dbo_Validated_Inspections.Validate_Date AS [Date of Upload],
dbo_Checklist.GTM_Modified_Date AS [Date of GTM Action],
CountBusinessDays([Validate_Date],[GTM_Modified_Date]) AS [Business Days
Between Upload and GTM Action]
FROM (dbo_Inspection INNER JOIN dbo_Validated_Inspections ON
dbo_Inspection.Inspection_Id = dbo_Validated_Inspections.Inspection_Id) INNER
JOIN dbo_Checklist ON dbo_Inspection.Inspection_Id =
dbo_Checklist.Inspection_Id
GROUP BY dbo_Inspection.Inspection_Id, dbo_Inspection.PIH_Project,
dbo_Validated_Inspections.Validate_Date, dbo_Checklist.GTM_Modified_Date,
CountBusinessDays([Validate_Date],[GTM_Modified_Date]),
dbo_Checklist.Question_No
HAVING (((dbo_Validated_Inspections.Validate_Date) Between #3/1/2006# And
#4/1/2006#) AND ((dbo_Checklist.Question_No)="FINAL"))
ORDER BY dbo_Validated_Inspections.Validate_Date,
dbo_Inspection.Inspection_Id;
Please help
between Jan and Feb and it is fine
SELECT dbo_Inspection.Inspection_Id AS [Inspection ID],
dbo_Inspection.PIH_Project AS [PIC Development Number],
dbo_Validated_Inspections.Validate_Date AS [Date of Upload],
dbo_Checklist.GTM_Modified_Date AS [Date of GTM Action],
CountBusinessDays([Validate_Date],[GTM_Modified_Date]) AS [Business Days
Between Upload and GTM Action]
FROM (dbo_Inspection INNER JOIN dbo_Validated_Inspections ON
dbo_Inspection.Inspection_Id = dbo_Validated_Inspections.Inspection_Id) INNER
JOIN dbo_Checklist ON dbo_Inspection.Inspection_Id =
dbo_Checklist.Inspection_Id
GROUP BY dbo_Inspection.Inspection_Id, dbo_Inspection.PIH_Project,
dbo_Validated_Inspections.Validate_Date, dbo_Checklist.GTM_Modified_Date,
CountBusinessDays([Validate_Date],[GTM_Modified_Date]),
dbo_Checklist.Question_No
HAVING (((dbo_Validated_Inspections.Validate_Date) Between #3/1/2006# And
#4/1/2006#) AND ((dbo_Checklist.Question_No)="FINAL"))
ORDER BY dbo_Validated_Inspections.Validate_Date,
dbo_Inspection.Inspection_Id;
Please help