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 Mike Lewis 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: *

  1. colpac

    Building a Group on a Query

    Are you saying that if I did NOT have to specify the field to sort, this would not be a problem? I've tried selecting the field to sort in the group building wizard and I've tried leaving it blank. I just don't understand why the group I'm building on the query ignores the sort order command.
  2. 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...
  3. 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