Hello:
I'm doing queries on sales order history. The tables I have used so far are:
OESalesOrderHeader_ao80ahed
OESalesOrderDetaiol_ao80alin

The problem is that these tables only go back a couple of months. I know there are tables out there because I can look up old orders.

Does anyone know where the history of all order headers and details would be stored?

Thanks in advance. I tried other order entry tables with the "History" name, but the queries just hang up and I end up having to terminate the Microsoft Access task.

Rich Locus
_________________________
Rich Locus
Marco Pharma, LLC