P prabhu Registered User. Local time Today, 17:55 Joined Apr 21, 2010 Messages 54 Sep 3, 2010 #1 Please look into the attachment... My table contains the data like this and i want to filter out the datas where colums G & H are not matching... how to get this... Attachments Book1.xls Book1.xls 34.5 KB · Views: 87
Please look into the attachment... My table contains the data like this and i want to filter out the datas where colums G & H are not matching... how to get this...
N namliam The Mailman - AWF VIP Local time Today, 17:55 Joined Aug 11, 2003 Messages 11,695 Sep 3, 2010 #2 Select .. from yourtable where Column1 <> Column2 ??
P prabhu Registered User. Local time Today, 17:55 Joined Apr 21, 2010 Messages 54 Sep 3, 2010 #3 Thank you... I got another question, when i use < symbol to find out the dates less than today, its giving me all the values, including dates greater than Today also. What is the problem in my approach?
Thank you... I got another question, when i use < symbol to find out the dates less than today, its giving me all the values, including dates greater than Today also. What is the problem in my approach?
N namliam The Mailman - AWF VIP Local time Today, 17:55 Joined Aug 11, 2003 Messages 11,695 Sep 3, 2010 #4 Make sure the field your comparing to is a date field, not a text string.
