Order By Problem (1 Viewer)

Meltdown · May 20, 2014

In a query I'm trying to return a list of rows sorted by ServiceType Ascending and then the last item in the list should be a row called "Add Edit Value" (see screenshot).

If I 'ORDER BY 2' then the "Add/Edit" row appears at the top which is not what i want.

My SQL:
SELECT '' As ServiceTypeID, 'ADD/EDIT VALUES' As ServiceType FROM ServiceTypes UNION SELECT ServiceTypes.ServiceTypeID, ServiceTypes.ServiceType FROM ServiceTypes
ORDER BY 1 DESC;

Appreciate any help.

Regards
Melt

pr2-eugin · May 20, 2014

Well the ORDER BY does what you ask it to do, but not what you want to do. You might need a sprinkle of VBA to get this going !

JHB · May 21, 2014

If you can "live" with a space in front of ' ADD/EDIT VALUES' then:

Code:

SELECT '' As ServiceTypeID, ' ADD/EDIT VALUES' As ServiceType FROM ServiceTypes 
UNION SELECT ServiceTypes.ServiceTypeID, ServiceTypes.ServiceType FROM ServiceTypes
ORDER BY ServiceType DESC

Meltdown · May 22, 2014

Thanks for the replies.

JHB, that won't work as I need the ServiceType Ascending, which will still leave the Add/Edit value at the top of the list.

Regards
Melt

JHB · May 23, 2014

Yes sorry, I forgot the Ascending part, so you need as pr2-eugin wrote some VBA code, I've made an example for you in the attached database.

Meltdown · May 25, 2014

Thanks a lot JHB -- nice piece of work!

Regards
Melt

Order By Problem (1 Viewer)

Meltdown

Registered User.

Attachments

pr2-eugin

Super Moderator

JHB

Have been here a while

Meltdown

Registered User.

JHB

Have been here a while

Attachments

Meltdown

Registered User.

Similar threads

Users who are viewing this thread