Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kcary
  • Content: Threads
  • Order by date
  1. kcary

    Eliminate duplicate records in a table

    I tried this starting at the query level and haven't had lotsa luck. What I'm using now is a maketable qry which leaves me with a table containing duplicate records. I'd like to filter out the records where ALL fields match any other record in the table. Like this: F1 F2 F3 F4...
  2. kcary

    Query for duplicate field value

    I'm using the standard 'In(Select...' to find records with duplicate field values. Now that I have the list, I'd like to view only those where all fields in the duplicate records are not equal. For instance: a b c d - will show a b c x a b c d - will not show a b c d I've tried...

Part and Inventory Search

Back
Top