SQL Query Error

[Newbie19]

When I run this query in my sql query prompt, it comes out with the correct results, but when I but it into the VBA prompt for my excel program, it doesn't display the correct results.

Any ideas?

 SELECT     dbo.Defects.DefectId, dbo.Defects.Name, dbo.WorkflowSteps.StepName, dbo.PriorityTypes.Name AS PriorityName, dbo.SeverityTypes.Name AS Severity,  dbo.Defects.BuildNumber, dbo.DefectCustomFields.Custom_86 AS TargetBuildNumber, dbo.Defects.BuildNumberOfFix,      CONVERT(varchar(20), dbo.Users.FirstName) + ' ' + CONVERT(varchar(20), dbo.Users.LastName) as Creator,  CONVERT(varchar(20), Users_1.FirstName) + ' ' + CONVERT(varchar(20), Users_1.LastName)    AS AssignedUser, dbo.Projects.Name AS ProjectName
 
FROM         dbo.Projects INNER JOIN
 dbo.Defects ON dbo.Projects.ProjectId = dbo.Defects.ProjectId INNER JOIN 
    dbo.Users ON dbo.Defects.CreatorId = dbo.Users.UserId INNER Join                 dbo.PriorityTypes ON dbo.Defects.PriorityTypeId = dbo.PriorityTypes.PriorityTypeId INNER JOIN 
                  dbo.SeverityTypes ON dbo.Defects.SeverityTypeId = dbo.SeverityTypes.SeverityTypeId INNER JOIN
                           dbo.StatusTypes ON dbo.Defects.StatusTypeId = dbo.StatusTypes.StatusTypeId INNER JOIN 
                         dbo.WorkflowSteps ON dbo.Defects.WorkflowStepId = dbo.WorkflowSteps.WorkflowStepId INNER JOIN
                         dbo.DefectCustomFields ON dbo.Defects.DefectId = dbo.DefectCustomFields.DefectId  LEFT OUTER JOIN
dbo.Users AS Users_1 ON dbo.Defects.AssignedToId = Users_1.UserId
 
WHERE     (dbo.Defects.StatusTypeId IN (9, 10, 1, 11, 2, 3, 8)) AND (dbo.Projects.ProjectId IN (" + projIds + ")) AND(dbo.Defects.DefectId NOT IN  
 
(SELECT     dbo.defects.DefectId 
FROM          dbo.Defects AS Defects_1 
 WHERE      (dbo.defects.LastUpdatedDateTime < '" + DefectClosedFilterDate + "') AND (dbo.defects.StatusTypeId = 8) AND (Defects.ProjectId IN (" + projIds + ")))) 
 
ORDER BY dbo.WorkflowSteps.StepName, dbo.PriorityTypes.Name, dbo.Defects.DefectId DESC
 

[Newbie19]

I figured the issue out, I didn't have my variables declared.