SQL code help in excel vba

[lpking2005]

Hi,

Im not sure if this belongs in Excel or Access forum section.


I have the following sql code which is working lovely but i need to modify it.

sSql = "SELECT * FROM " & i & " WHERE [Pick Status] = 'Ordered'"

So obviously it looks at a table and retrieves only records that have a status of "Ordered" and places them one by one into an excel sheet.

But recently i had to change the table and add an 'Order Priority' column.
So every order entered into the database now has a priority number of 2 (low priority) but if the user adds a high priority order, the number will be 1.

What i need is to still select the orders that have the status 'Ordered' but also check to see if the 'Order Priority' number is set as 1 and select that first before moving onto records with a number 2 priority.

I hope this isnt confusing!?

Any help will be very much appreciated.

 

[Asala42]

Is the [Order Priority] field already getting pulled then? It sounds like you just want to add an "Order By" statement so that the 1's are sorted towards the top.

Try:

sSql = "SELECT * FROM " & i & " WHERE [Pick Status] = 'Ordered' Order by [Order Priority]"

 

[lpking2005]

Thank you for the reply!

That makes sense but it is still not selecting the Priority 1 order first or not at least putting it at the top of the list in excel sheet.

 

[lpking2005]

i have just worked it out!

I have left the sql statement the same and instead changed the record sort code: rst.sort[ID] to rst.sort[OrderPriority]

It seems to do the trick.

Thank you anyway!