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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
order query results by a calculated field.....PLEASE!!!!!!!!!
Thanks for the reply, Terry. I've tried removing the alias from the order by clause, but now I simply get an error "unknown". I've used the debug window to check the values of the alias LOSS and it definitely works, but I can't order the results! Any ideas? Herbie1- Herbie1
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
order query results by a calculated field.....PLEASE!!!!!!!!!
I am using a VB6 App to query an ACCESS 97 database. I would like to use two of the database fields to perform a calculation. The answer, a percentage, is then stored in an alias named 'LOSS'. However, when I attempt to use the new alias LOSS in the ORDER BY section of my query, it does not...- Herbie1
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
