Solved Query sorting
- Thread starter quest
- Start date
last line "what is wrong" not.
Gasman
Enthusiastic Amateur
- Local time
- Today, 00:44
- Joined
- Sep 21, 2011
- Messages
- 16,607
Can you give me an example?
SELECT Delovodnik.DelovodnikID, Left([Ознака],4) AS Proba1, DatePart("yyyy",[Датум]) AS ГодинаПребарување1, Delovodnik.ОрганизационаЕдиница, Delovodnik.ОсновенБрој, Delovodnik.Подброеви, Delovodnik.Пренос, Delovodnik.Предмет, Delovodnik.ДатумНаПриемот, Delovodnik.[НазивИседиштеНаПравнотоЛице/органот], Delovodnik.Доставено, Delovodnik.БројИдатум, Format([ОрганизационаЕдиница],"00") & "-" & [ОсновенБрој] & "/" & [Подброеви] AS Proba, Delovodnik.Датум, Delovodnik.Ознака, Delovodnik.Документ, Delovodnik.Забелешка, Delovodnik.FizickaSostojba, Val(Mid([Забелешка],InStr(1,[Забелешка],"л*")+1)) AS Листови, Mid([Забелешка],InStrRev([Забелешка],"и ")+1) AS Expr1
FROM Delovodnik
WHERE (((DatePart("yyyy",[Датум])) Like "*" & [forms]![Delovodnik Query3].[combo58] & "*") AND ((Delovodnik.ОрганизационаЕдиница)<>5) AND ((Delovodnik.Ознака) Like "*трајно*") AND ((Delovodnik.Забелешка)<>"0 лист/а и 0 фотoграфија/и"))
ORDER BY Left([Ознака],4), DatePart("yyyy",[Датум]), Delovodnik.ОсновенБрој, Delovodnik.Подброеви
UNION SELECT tblDelovodnik1.DelovodnikID, Left([Ознака],4) AS Proba1, DatePart("yyyy",[Датум]) AS ГодинаПребарување1, tblDelovodnik1.ОрганизационаЕдиница, tblDelovodnik1.ОсновенБрој, tblDelovodnik1.Подброеви, tblDelovodnik1.Пренос, tblDelovodnik1.Предмет, tblDelovodnik1.ДатумНаПриемот, tblDelovodnik1.[НазивИседиштеНаПравнотоЛице/органот], tblDelovodnik1.Доставено, tblDelovodnik1.БројИдатум, Format([ОрганизационаЕдиница],"00") & "-" & [ОсновенБрој] & "/" & [Подброеви] AS Proba, tblDelovodnik1.Датум, tblDelovodnik1.Ознака, tblDelovodnik1.Документ, tblDelovodnik1.Забелешка, tblDelovodnik1.FizickaSostojba, Val(Mid([Забелешка],InStr(1,[Забелешка],"л*")+1)) AS Листови, Mid([Забелешка],InStrRev([Забелешка],"и ")+1) AS Expr1
FROM tblDelovodnik1
WHERE (((DatePart("yyyy",[Датум])) Like "*" & [forms]![Delovodnik Query3].[combo58] & "*") AND ((tblDelovodnik1.ОрганизационаЕдиница)<>5) AND ((tblDelovodnik1.Ознака) Like "*трајно*") AND ((tblDelovodnik1.Забелешка)<>"0 лист/а и 0 фотoграфија/и"));
here is the whole query. can you understand this or should i translate it.
can not be the last line. this query is made from two select queries. first before union and second after that.
do not accept that. report mistake.
tried and didn't work if my syntax was right: ORDER BY 2,3,4,5
This needs to be 3 queries. 1 for the first SELECT, 1 for the second SELECT and then the third should be the UNION that just brings the results together and that is the one that you should ORDER.
You're just trying to do to much in one query and its screwing you up. So take the first SELECT and make it its own query (sub1) . Run it, make sure it returns the right results. Then take the second SELECT and make it its own query (sub2). Run it, make sure it returns the right results. Once both of those are working independently, then you make a third query to just UNION those and ORDER them:
You're just trying to do to much in one query and its screwing you up. So take the first SELECT and make it its own query (sub1) . Run it, make sure it returns the right results. Then take the second SELECT and make it its own query (sub2). Run it, make sure it returns the right results. Once both of those are working independently, then you make a third query to just UNION those and ORDER them:
Code:
SELECT * FROM sub1
UNION ALL
SELECT * FROM sub2
ORDER BY Left([Ознака],4), DatePart("yyyy",[Датум]), Delovodnik.ОсновенБрој, Delovodnik.ПодброевиGasman
Enthusiastic Amateur
- Local time
- Today, 00:44
- Joined
- Sep 21, 2011
- Messages
- 16,607
If you do not try suggestions, waste of time asking for help?
it is checked. this union query was made by combining two select queries. both have same sorting and work with them. in union can be only one order by and not as the last line. select query above union is the first one and second select query is below union.If you do not try suggestions, waste of time asking for help?
it is made that way and works independently but not in union query.
isladogs
MVP / VIP
- Local time
- Today, 00:44
- Joined
- Jan 14, 2017
- Messages
- 18,796
As was explained more than once in this thread, the ORDER BY clause in a UNION query is based on the final SELECT.
You stated that you did not accept that.
the way i tried before did not accept it and i tried many times. this time with order by n and deleting the ";" accept it. i glad it is solved. if i could find mistake i wouldn't post here. i learned this time and i wont make this mistake twice.
