Solved: Access - Sorting in a query

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

coachdan32

Thread Starter
Joined
Nov 13, 2003
Messages
1,021
I am trying to sort the results of a query alphabetically, but the default ascending sort returns parenthesis before it starts into the alphabet. It is a song list and the default sort lists songs like "(This Song) Starts With T" before songs that start with "A" like "A Complete Mess Of My List". Is there a workaround that will allow me to have it ignore the parenthesis?
 
Joined
Jul 29, 2001
Messages
21,334
You could trim or replace that charachter in a seperate field in your query and have it sort that field.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top