G
Guest
I need to sort by number of Rides Asc and then last name Asc, however if
Rides = 0 then I want the sort order Rides Asc and last name Desc.
Any ideas?
Rides = 0 then I want the sort order Rides Asc and last name Desc.
Any ideas?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
I didn't try i, but I hope the Idea will make sense
Order By Rides Asc , iif([Rides] = 0,[last name],"") Desc , [last name] Asc
Order By Rides Asc , iif([Rides] = 0,[last name],"") Desc , [last name] Asc
G
Guest
Didn't work, got " you tried to execute a query that did not include the
specified expression......as part of an aggregate function"
specified expression......as part of an aggregate function"
Ofer Cohen said:I didn't try i, but I hope the Idea will make sense
Order By Rides Asc , iif([Rides] = 0,[last name],"") Desc , [last name] Asc
--
Good Luck
BS"D
Paul Dennis said:I need to sort by number of Rides Asc and then last name Asc, however if
Rides = 0 then I want the sort order Rides Asc and last name Desc.
Any ideas?
G
Guest
Can you post the full SQL?
--
Good Luck
BS"D
--
Good Luck
BS"D
Paul Dennis said:Didn't work, got " you tried to execute a query that did not include the
specified expression......as part of an aggregate function"
Ofer Cohen said:I didn't try i, but I hope the Idea will make sense
Order By Rides Asc , iif([Rides] = 0,[last name],"") Desc , [last name] Asc
--
Good Luck
BS"D
Paul Dennis said:I need to sort by number of Rides Asc and then last name Asc, however if
Rides = 0 then I want the sort order Rides Asc and last name Desc.
Any ideas?
G
Guest
SELECT [Temp - TPFS - Riders].Year, [Rider Details].[Last Name], [Temp - TPFS
- Riders].Rides
FROM [Temp - TPFS - Riders], [Rider Details]
GROUP BY [Temp - TPFS - Riders].Year, [Rider Details].[Last Name], [Temp -
TPFS - Riders].Rides
ORDER BY [Temp - TPFS - Riders].Rides DESC,[Rider Details].[Last Name] DESC;
- Riders].Rides
FROM [Temp - TPFS - Riders], [Rider Details]
GROUP BY [Temp - TPFS - Riders].Year, [Rider Details].[Last Name], [Temp -
TPFS - Riders].Rides
ORDER BY [Temp - TPFS - Riders].Rides DESC,[Rider Details].[Last Name] DESC;
Ofer Cohen said:Can you post the full SQL?
--
Good Luck
BS"D
Paul Dennis said:Didn't work, got " you tried to execute a query that did not include the
specified expression......as part of an aggregate function"
Ofer Cohen said:I didn't try i, but I hope the Idea will make sense
Order By Rides Asc , iif([Rides] = 0,[last name],"") Desc , [last name] Asc
--
Good Luck
BS"D
:
I need to sort by number of Rides Asc and then last name Asc, however if
Rides = 0 then I want the sort order Rides Asc and last name Desc.
Any ideas?
G
Guest
Try
SELECT [Temp - TPFS - Riders].Year, [Rider Details].[Last Name], [Temp - TPFS
- Riders].Rides
FROM [Temp - TPFS - Riders], [Rider Details]
GROUP BY [Temp - TPFS - Riders].Year, [Rider Details].[Last Name], [Temp -
TPFS - Riders].Rides, IIf([Temp - TPFS - Riders].Rides = 0,[Rider
Details].[Last Name],"")
ORDER BY [Temp - TPFS - Riders].Rides ASC , IIf([Temp - TPFS - Riders].Rides
= 0,[Rider Details].[Last Name],"") DESC,[Rider Details].[Last Name] ASC
--
Good Luck
BS"D
SELECT [Temp - TPFS - Riders].Year, [Rider Details].[Last Name], [Temp - TPFS
- Riders].Rides
FROM [Temp - TPFS - Riders], [Rider Details]
GROUP BY [Temp - TPFS - Riders].Year, [Rider Details].[Last Name], [Temp -
TPFS - Riders].Rides, IIf([Temp - TPFS - Riders].Rides = 0,[Rider
Details].[Last Name],"")
ORDER BY [Temp - TPFS - Riders].Rides ASC , IIf([Temp - TPFS - Riders].Rides
= 0,[Rider Details].[Last Name],"") DESC,[Rider Details].[Last Name] ASC
--
Good Luck
BS"D
Paul Dennis said:SELECT [Temp - TPFS - Riders].Year, [Rider Details].[Last Name], [Temp - TPFS
- Riders].Rides
FROM [Temp - TPFS - Riders], [Rider Details]
GROUP BY [Temp - TPFS - Riders].Year, [Rider Details].[Last Name], [Temp -
TPFS - Riders].Rides
ORDER BY [Temp - TPFS - Riders].Rides DESC,[Rider Details].[Last Name] DESC;
Ofer Cohen said:Can you post the full SQL?
--
Good Luck
BS"D
Paul Dennis said:Didn't work, got " you tried to execute a query that did not include the
specified expression......as part of an aggregate function"
:
I didn't try i, but I hope the Idea will make sense
Order By Rides Asc , iif([Rides] = 0,[last name],"") Desc , [last name] Asc
--
Good Luck
BS"D
:
I need to sort by number of Rides Asc and then last name Asc, however if
Rides = 0 then I want the sort order Rides Asc and last name Desc.
Any ideas?
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.