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
