Unique Display Problem

[ietprofessional]

I want to write a query that will display records that have x in the numberone column and the rest displaying below, ordered by column numbertwo.

Can someone help with this?

THANKS!

 

[PHV]

Can you please post some input example and expected result ?

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

 

[ietprofessional]

I need this kind of output, assuming the first column is normally the ordered column. Instead I need the fourth column that equals 'Processing' to come first and then the stuff below should be ordered by the first column.

8 - FirstName8 - LastName8 - Processing
9 - FirstName9 - LastName9 - Processing
1 - FirstName1 - LastName1 - Some Description
2 - FirstName2 - LastName2 - Words
3 - FirstName3 - LastName3 - Text

 

[PHV]

Add a sort field in your query:
SortField: IIf([column4]="Processing", 1, 2)
Sort by this field and the 1st column

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

 

[ietprofessional]

SELECT Table.x0, Table.x1
FROM Table
order by IIf([x1]="Processing", 1, 2)and Table.x0


This isn't working when I put the 'and Table.x0 ' in the query. Without the 'and Table.x0' part it does put the columns containing 'Processing' on top though.

What am I doing wrong?

 

[ietprofessional]

This works:

SELECT Table.x0, Table.x1
FROM Table
order by IIf([x1]="Processing", 1, 2), Table.x0

What exactly is the second and third params doing in the IIF?

 

[OhioSteve]

I can't understand everything that you have posted. However, you seem to want a two-part sort. Try this~

ORDER BY IIf([x1]="Processing", 1, 2), table.x0;

 

[ietprofessional]

What exactly are the second and third params doing in the IIF statement?

 

[PHV]

What exactly is the second and third params doing in the IIF
IIf is a VBA function, so I suggest you to press the F1 key when the cursor is on the IIf word while in VBE.

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

 

[ietprofessional]

Is there an equivalent if statement for sql server?

Thanks!

 

[PHV]

Take a look at something like CASE WHEN

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