Sorting in a query

[gscma1]

I'm sure there is a very simple answer to this but here we go...

if i want all records with location ending "ON" in descending order, what do i put in the sort criteria of my query??

Please help!

 

[AlexCuse]

In 'location' column, for criteria enter:

right(location,2) = "ON"

for sort enter:

descending

in whichever column you want to sort on.

HTH,

Alex

 

[gscma1]

That doesnt seem to work, it brings up random records, am i doing something wrong?
i have entered it exactly how you have said

 

[PHV]

And what about explaining exactly (with some input samples and expected result) what you want to do ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Golom]

The SQL view of the query should look something like

Select Location, fld1, fld2, ...

From myTable

Where Location LIKE '*ON'

Order By Location DESC

where "Location, fld1, fld2, ..." is a list of the fields that are being returned by the query.

 

[gscma1]

Thank you very much Golom, that worked a treat!

 

[AlexCuse]

I have no idea why like "*ON" would work and right(location,2) = "ON" would not. Possibly a data type issue?

I'm glad you got it to work though. Next time I'll post SQL View so there's no room for error.

 

[gscma1]

Possibly i made a typo error, thanks for your help though. much appreciated.