1 Reply Latest reply: Jan 11, 2016 4:19 AM by Jonathan Dienst RSS

    Where clause not working for Ms-Access datasource

    Priyanka Pandey

      Hi Team,

       

      I want to load data from MS-Access with limiting data from a particular column i.e Team in my case. I have written below script but could not achieve it. It is throwing some error

       

       

      Attendance1:

       

        Load Attendance,

      Team,

      Emp Name,

      Designation

      Select * from Attandence where Team in('ABC','AVP','PQR');

       

      Please help me.

       

      Thanks in Advance

       

      Regards

      Priyanka

       

       

       

        • Re: Where clause not working for Ms-Access datasource
          Jonathan Dienst

          Your SQL expression looks fine, but you need a delimiters for Emp Name, semicolon after Designation, and a SQL keyword before the Select:

           

          Load Attendance,

          Team,

          [Emp Name],

          Designation;

          SQL Select * from Attandence where Team in('ABC','AVP','PQR');

           

          (Is the table name spelled correctly).

           

          If you supplied more information about the error, it would allow more accurate diagnosis. "Some error" could be just about anything...