Sort Order

[Paul Dennis]

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?

 

[Ofer Cohen]

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

 

[Paul Dennis]

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?

 

[Ofer Cohen]

Can you post the full SQL?
--
Good Luck
BS"D

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?

 

[Paul Dennis]

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;

Can you post the full SQL?
--
Good Luck
BS"D

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?

 

[Ofer Cohen]

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
ORDER BY [Temp - TPFS - Riders].Rides DESC,[Rider Details].[Last Name] DESC;

Can you post the full SQL?
--
Good Luck
BS"D

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?