My Query is
Select * from Order_Table where OrderNo
in(1,2,3,4,5,6,7,8,9,10,11,12,13,14,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,
...
Many, many similar rows deleted to make this less of a PITA to load...
...
21063,21065,21066,21067,21069,21070,21071,21072,21073,21074,21075,21076,21077,21078,21079,21080,21081,21082,21083,21084,21085,21086,21087,21088,21089,21090,21091,21092)
it gives me error like "
Query is too long" i have to delete record except this no what i have to do. please help me.... Database MS ACcess 2002-2003
[edit]Rows in HUGE query removed - was 20,000+ IDs - OriginalGriff[/edit]