access 2003 problem SELECT * INTO [test_table] FROM [old_table] ORDER BY [PH_ORDER]; (PH_ORDER is a unique numeric field) I thought this would be straight forward, but in some cases (particularly tables > 10,000 records) the resulting table will have some blocks of records (about 20) out of order. Typically when this occurs the table when opened will start with ,say, records 40-60 and then go back to 1. I need to connect our printing application directly to the Table, at present it is printing out of order. Does anyone have an explanation as to why this might be happening?
Thread Closed
This thread is kinda stale and has been closed but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.