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 gkittelson 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: mnl
  • Order by date
  1. mnl

    Query to remove duplicate lines

    I have a table that contains several fields. The fields are name, ssn, date, field a, and field b. Each line is duplicated, except in the second line field a and field b are always zero. The lines with these zero values are the ones I want to erase. The one quirk is that sometimes on the...

Part and Inventory Search

Back
Top