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 dencom 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: colpac
  • Content: Threads
  • Order by date
  1. colpac

    Building a Group on a Query

    Here's my query: SELECT C1.* ,C2.Userdef02 FROM CONTACT1 AS C1 JOIN CONTACT2 AS C2 ON C2.AccountNo = C1.AccountNo WHERE (C1.Key3 = 'K' AND C1.Key2 = 'T20') ORDER BY C2.Userdef02 desc When I execute the query, the order is descending as requested. However, when I build a group on this query...
  2. colpac

    Sorting Contact Groups

    I built a group of customers from the state of Texas and I sorted them by zip code. We work this list about once a year, but it is so large we don't usually get to every contact. When you activate the group, it begins with the lowest zip code so we always start there, which keeps us from...

Part and Inventory Search

Back
Top