HI,
EMPDT.Select(“[Department]='IT’or [Department]=‘Finance’ AND [Salary]<20000”).CopyToDataTable
I use the above query but I am getting output that is not correct. Where is my Mistake will someone please help me
Message Box
Name,Date of Joining,Department,Salary
Raghunath,6/7/1952,Finance,8000
Navnit,15/2/1971,IT,20000
Mahadeo,27/11/1920,IT,32000
Parth,28/01/2010,IT,35000
OK
Yoichi
(Yoichi)
2
Hi,
Can you try the following expression?
EMPDT.Select("([Department]='IT'or [Department]='Finance') AND [Salary]<20000").CopyToDataTable
Regards,
Hey Yoichi
Thanks Your query is working and issue resolved
Thanks
1 Like
Veera_Raj
(Veera Raj)
4
EMTP.Select(“[Department]='IT’ or [Department]=‘Finance’ )AND ([Salary]<20000”).CopyToDataTable