[MS_AccessPros] RE: Last Receipt with Vendor

 

Graham,

If I look at this linked SQL table in design view, it does not show an index on VENID_55. However it does have a key for VENID_55 and TNXDTE_55. Can I use that to speed up this query. If so how?  Right now this query is too slow to be useful. This table has over 77,000 records dating back to 2000. I'm going to look into purging some of these records. Perhaps I can eliminate the non-inventory receipts and limit the date range.

BTW, while you were out swimming, we got an ice storm over the weekend with sleet and freezing rain.

Doyce

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (7)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___