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!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sort on a List Box

Status
Not open for further replies.

Jamie2002

Technical User
Joined
Sep 17, 2001
Messages
62
Location
GB
How do you use the GROUP BY function to sort on a numerical field in a list box....?
Thanks

Jamie
 
need more information on what you are trying to do?
 
I've solved this now by creating a query from the SQL, updating the query to include the sort and then viewing it as SQL and copying it. The SQL script included a ORDER BY clause at the end which sorts the records.

I am still having problems though trying to right align numeric fields in a list box selection. Any ideas ?

eg the data is coming back like

Horse Racing £100,000.00
Football £5,000.00

As opposed to

Horse Racing £100,000.00
Football £5,000.00

Thanks Thanks

Jamie
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top