C crhodus Registered User. Local time Yesterday, 19:19 Joined Mar 16, 2001 Messages 257 Jul 24, 2001 #1 Can anyone tell me how to create a delete query? I want to delete any company that is listed more than onec in my table based on company number. (The company number is not the primary key for this table.)
Can anyone tell me how to create a delete query? I want to delete any company that is listed more than onec in my table based on company number. (The company number is not the primary key for this table.)
J Jack Cowley Registered User. Local time Today, 01:19 Joined Aug 7, 2000 Messages 2,639 Jul 24, 2001 #2 Look at the Query Wizards for creating a query to find duplicate records. Also Access help has instructions on how to create queries....
Look at the Query Wizards for creating a query to find duplicate records. Also Access help has instructions on how to create queries....
