Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    New Zealand
    Posts
    47

    Unanswered: Syntax error(operator missing)

    hi all

    I am getting this error message on this line..

    Syntax error(missing Operator)!

    sqlMastSpecs = (Nz("SELECT * FROM Mast_Machine WHERE (Mast_Machine.Mast_ID) = " + CStr(Nz(rstMast.Fields("Mast_ID").Value)) + " AND (Mast_Machine.Machine_ID) = " + (CStr(Nz(rstDetailLine.Fields("MachineID").Value)) )))

    I can't see where i am going wrong. Please help! Its driving me mad............!!

    thanks in advance. This is a query for a rst.
    Nerdy Girl

  2. #2
    Join Date
    Nov 2003
    Location
    Netherlands
    Posts
    85

    Re: Syntax error(operator missing)

    Originally posted by nerdy_girl
    hi all

    I am getting this error message on this line..

    Syntax error(missing Operator)!

    sqlMastSpecs = (Nz("SELECT * FROM Mast_Machine WHERE (Mast_Machine.Mast_ID) = " + CStr(Nz(rstMast.Fields("Mast_ID").Value)) + " AND (Mast_Machine.Machine_ID) = " + (CStr(Nz(rstDetailLine.Fields("MachineID").Value)) )))

    I can't see where i am going wrong. Please help! Its driving me mad............!!

    thanks in advance. This is a query for a rst.
    What I do is try the query without the and(adjust the ()) and see if it works. Then add the and part so you know where the operator is missing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •