Recent content by sarahdee

Hey! I wanted to say thank you for your help. I took a closer look at the lot numbers in teh IntLotData1 table and found six records that had duplicate lot numbers. I am in the process of deleting the lot numbers that are no longer in use and them I am going to index the IntLot field so that...

Thanks for the fast response! Would the fact that the IntLotData1 table is a linked table have any bearing on things? I looked at the data in both tables that you mentioned in your reply and found that the IntLotData1 table is actually linked to another db in different folder. I found the...

Hey Everyone! I am new to this site and have a query question that has been driving me nuts! I inherited an Access database (created in Access 2000 probably. We are currently using Access 2010) at work that is used to record machine production data and create reports to show efficiency (among...