order by vs sort

[DirtDawg]

Hello all,

I have an Access program that outputs to a report.
I would like set the order based on one column. I would like to have one selection of the records be shown either first or last. Then the rest of the records to be shown Ascending. I there anyway to do this?

Thanks in advance

 

[formerTexan]

Hunnicutt,

Wiser readers may offer a better solution, but here is one.

You will need to use a UNION query.

SELECT tblSet.PK, tblSet.Info FROM tblSet WHERE (((tblSet.Info)= "gizmo"));

UNION SELECT tblSet.PK, tblSet.Info FROM tblSet WHERE (((tblSet.Info)<>gizmo)) ORDER BY tblSet.Info;

The preceeding example will produce a recordset containing all rows with tblSet.Info, but having "gizmo" as the first row.

Cheers,
Bill

 

[TonyJollans]

Hi Hunnicutt,

Here's another way. I don't know which is better; I'd be interested in others' views.

[blue][tt]SELECT YourTable.*
FROM YourTable
ORDER BY YourTable.YourColumn = YourValue,
YourTable.YourColumn;[/tt][/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.