Union Query Order By Specific Row Values

[Dormie]

Hi, I've have a union query that I've been playing around with the Order By clause. I was wondering If I can specify the actual order by name in that column for example.

If I have a column with:


FirstName:
Adam
Brad
Chris

Instead of using
Order by FirstName DESC;

Can I specify the specific order by the values in the column?
Order By FirstName Brad Chris Adam

[pbaldy]

In a word, no. You can have a "sort order" field in the same table and sort by that.

[Dormie]

Thank you for the quick response. I added a "sort order" field and is doing exactly what I want! Thanks again!

[pbaldy]

Happy to help!