Mark Wheeler wrote: > Hi, > > Just a quick question. Is it possible to sort a table by last name > when the first and last name are in the same field? For example, if I > had to sort the following by last name: > > Jim Berg > Ray Shwartz > Al Peking > Nick Cutter > > How would, if it can, be done within the query? Again, each field has > the first and last name in it. > > Thanks, > > Mark
01282008 2003 GMT-6 You cant sort the table but, if you pull the data and separate it out, you could then sort by last name. Wade
