looks like your code missed out the parenthesis ( ) around the conditiondelete from INVOICE where (Acct_link = '9061' and invdate = '2011-06-30 00:00:00.000')or (Acct_link = '9062' and invdate = '2011-06-30 00:00:00.000')or (Acct_link = '9063' and invdate = '2011-06-30 00:00:00.000')or (Acct_link = '9064' and invdate = '2011-06-30 00:00:00.000')or (Acct_link = '9065' and invdate = '2011-06-30 00:00:00.000')or (Acct_link = '9066' and invdate = '2011-06-30 00:00:00.000')
to simplify your code, you can change towhere invdate = '2011-06-30'and Acct_link in ('9061' , '9062', '9063', ....)
KH[spoiler]Time is always against us[/spoiler]