Syntax Error

[nwalk81]

Hello All,

Can someone please help, I can not figure out this error and I can not move forward in my project until I do

(((Resolution.Date)>=[Forms]![Closed Issues Report Options]![cmbBeginDate] AND (Resolution.Date)<=[Forms]![Closed Issues Report Options]![cmbEndDate]) AND ((EmpInfo.[VZW Area Code])=[Forms]![Closed Issues Report Options]![cmbArea]) And ((tmpEmpOnLeave.[Location Descr])=[Forms]![Closed Issues Report Options]![cmbLoc])

Thank you for you assistance!

 

[rac2]

What is the error message?
Why not post the whole query.

 

[nwalk81]

The error just says syntax error in query expression with an emphasis on the code above. I didn't post the whole thing because it is large, but you asked for it so

SELECT Resolution.Date, EmpInfo.[VZW Area Code], tmpEmpOnLeave.[Location Descr], Resolution.[Resolution Type Lookup], EmpInfo.HRAnalystID, EmpInfo.[First Name], EmpInfo.Last, EmpInfo.[Job Title], DateDiff('y',EmpInfo.[Service Dt],[Claim Info].[Last Date]) AS Tenure, DateDiff('y',[Claim Info].[Last Date],[Resolution].[Date]) AS [Days Absent]
FROM ((tmpEmpOnLeave INNER JOIN EmpInfo ON tmpEmpOnLeave.ID = EmpInfo.ID) INNER JOIN [Claim Info] ON tmpEmpOnLeave.[Claim Code] = [Claim Info].[Claim Code]) INNER JOIN Resolution ON [Claim Info].[Claim Code] = Resolution.[Claim ID]
WHERE (((Resolution.Date)>=[Forms]![Closed Issues Report Options]![cmbBeginDate]) AND ((Resolution.Date)<=[Forms]![Closed Issues Report Options]![cmbEndDate]) AND ((EmpInfo.[VZW Area Code])=[Forms]![Closed Issues Report Options]![cmbArea]) And ((tmpEmpOnLeave.[Location Descr])=[Forms]![Closed Issues Report Options]![cmbLoc]) AND ((Resolution.[Resolution Type Lookup])=[Forms]![Closed Issues Report Options]![cmdResolutionType])) OR (((Resolution.Date)>=[Forms]![Closed Issues Report Options]![cmbBeginDate] AND (Resolution.Date)<=[Forms]![Closed Issues Report Options]![cmbEndDate]) AND (([tmpEmpOnLeave].[Location Descr])=[Forms]![Closed Issues Report Options]![cmbLoc]) AND ((Resolution.[Resolution Type Lookup])=[Forms]![Closed Issues Report Options]![cmdResolutionType]) AND (([EmpInfo].[VZW Area Code])=[Forms]![Closed Issues Report Options]![cmbArea]) Is Null) OR (((Resolution.Date)>=[Forms]![Closed Issues Report Options]![cmbBeginDate] AND (Resolution.Date)<=[Forms]![Closed Issues Report Options]![cmbEndDate]) AND ((EmpInfo.[VZW Area Code])=[Forms]![Closed Issues Report Options]![cmbArea]) AND ((Resolution.[Resolution Type Lookup])=[Forms]![Closed Issues Report Options]![cmdResolutionType]) AND ((([tmpEmpOnLeave].[Location Descr])=[Forms]![Closed Issues Report Options]![cmbLoc]) Is Null)) OR (((Resolution.Date)>=[Forms]![Closed Issues Report Options]![cmbBeginDate] AND (Resolution.Date)<=[Forms]![Closed Issues Report Options]![cmbEndDate]) AND ((EmpInfo.[VZW Area Code])=[Forms]![Closed Issues Report Options]![cmbArea]) AND ((tmpEmpOnLeave.[Location Descr])=[Forms]![Closed Issues Report Options]![cmbLoc]) AND ((([Resolution].[Resolution Type Lookup])=[Forms]![Closed Issues Report Options]![cmdResolutionType]) Is Null)) OR (((Resolution.Date)>=[Forms]![Closed Issues Report Options]![cmbBeginDate] AND (Resolution.Date)<=[Forms]![Closed Issues Report Options]![cmbEndDate]) AND ((([EmpInfo].[VZW Area Code])=[Forms]![Closed Issues Report Options]![cmbArea]) Is Null) AND ((([tmpEmpOnLeave].[Location Descr])=[Forms]![Closed Issues Report Options]![cmbLoc]) Is Null) AND ((([Resolution].[Resolution Type Lookup])=[Forms]![Closed Issues Report Options]![cmdResolutionType]) Is Null) OR (((Resolution.Date)>=[Forms]![Closed Issues Report Options]![cmbBeginDate] AND (Resolution.Date)<=[Forms]![Closed Issues Report Options]![cmbEndDate]) AND ((([EmpInfo].[VZW Area Code])=[Forms]![Closed Issues Report Options]![cmbArea]) Is Null) AND ((([tmpEmpOnLeave].[Location Descr])=[Forms]![Closed Issues Report Options]![cmbLoc]) Is Null) AND ((([Resolution].[Resolution Type Lookup])=[Forms]![Closed Issues Report Options]![cmdResolutionType])  OR (((Resolution.Date)>=[Forms]![Closed Issues Report Options]![cmbBeginDate] AND (Resolution.Date)<=[Forms]![Closed Issues Report Options]![cmbEndDate]) AND ((([EmpInfo].[VZW Area Code])=[Forms]![Closed Issues Report Options]![cmbArea]) Is Null) AND ((([tmpEmpOnLeave].[Location Descr])=[Forms]![Closed Issues Report Options]![cmbLoc]) AND ((([Resolution].[Resolution Type Lookup])=[Forms]![Closed Issues Report Options]![cmdResolutionType]) Is Null) OR (((Resolution.Date)>=[Forms]![Closed Issues Report Options]![cmbBeginDate] AND (Resolution.Date)<=[Forms]![Closed Issues Report Options]![cmbEndDate]) AND ((([EmpInfo].[VZW Area Code])=[Forms]![Closed Issues Report Options]![cmbArea]) AND ((([tmpEmpOnLeave].[Location Descr])=[Forms]![Closed Issues Report Options]![cmbLoc]) Is Null) AND ((([Resolution].[Resolution Type Lookup])=[Forms]![Closed Issues Report Options]![cmdResolutionType]) Is Null));

Thanks for replying

 

[rac2]

Well, the initial post might be layed out like this

(
  (
    (Resolution.Date) >= [Forms]![Closed Issues Report Options]![cmbBeginDate]
    AND
    (Resolution.Date) <= [Forms]![Closed Issues Report Options]![cmbEndDate]
  )
  AND
  (
    (EmpInfo.[VZW Area Code]) = [Forms]![Closed Issues Report Options]![cmbArea]
  )
  And
  (
    (tmpEmpOnLeave.[Location Descr]) = [Forms]![Closed Issues Report Options]![cmbLoc]
  )

which suggests the problem is unbalanced parentheses.


But that may not be the whole problem.

(
  (
    (Resolution.Date) >= [Forms]![Closed Issues Report Options]![cmbBeginDate]
    AND
    (Resolution.Date) <= [Forms]![Closed Issues Report Options]![cmbEndDate]
  )
  AND
  (
    (
      ([EmpInfo].[VZW Area Code])=[Forms]![Closed Issues Report Options]![cmbArea]
    )
    AND
    (
      (
        ([tmpEmpOnLeave].[Location Descr])=[Forms]![Closed Issues Report Options]![cmbLoc]
       ) Is Null
    )
    AND
    (
      (
        ([Resolution].[Resolution Type Lookup])=[Forms]![Closed Issues Report Options]![cmdResolutionType]
      ) Is Null
    )
  );

It appears there is still an unbalanced paren.

But I am wondering about the two pieces like this

    AND
    (
      (
        ([Resolution].[Resolution Type Lookup])=[Forms]![Closed Issues Report Options]![cmdResolutionType]
      ) Is Null
    )

What does it mean to say that column equals value is null?