What is wrong with my query?

[SteveGr]

I run a sql query for my combo box.
when I change to sort ascending on any field, it stops working. When I take the "sort by" out of the query, it's OK.
I had this sorting before. . . any ideas anyone?

Thanks, Stevegr

 

[llkhoutx]

Use "Order BY" instead of "SORT BY."

 

[SteveGr]

I tried that and it didn't work either

 

[llkhoutx]

Post your sql; the good and the bad ones.

 

[SteveGr]

Works but not set Ascending:
SELECT [QRY_COMBINE_TABLES Query].[JOB NUMBER], [QRY_COMBINE_TABLES Query].[JOB NAME], [QRY_COMBINE_TABLES Query].VERSION, [QRY_COMBINE_TABLES Query].[FORM ID], [QRY_COMBINE_TABLES Query].[NET GOOD PRESS COUNT]
FROM [QRY_COMBINE_TABLES Query];

Does not work, set sorted to Ascending:
SELECT [QRY_COMBINE_TABLES Query].[JOB NUMBER], [QRY_COMBINE_TABLES Query].[JOB NAME], [QRY_COMBINE_TABLES Query].VERSION, [QRY_COMBINE_TABLES Query].[FORM ID], [QRY_COMBINE_TABLES Query].[NET GOOD PRESS COUNT]
FROM [QRY_COMBINE_TABLES Query]
ORDER BY [QRY_COMBINE_TABLES Query].[JOB NUMBER], [QRY_COMBINE_TABLES Query].[JOB NAME], [QRY_COMBINE_TABLES Query].VERSION;

 

[pdx_man]

... And all 3 fields are displayed in the combo box when the drop-down is clicked, but they are not sorted by the Job #?

 

[llkhoutx]

Your posted sql looks ok. Try copying it into the SQL view of a query and see if it will convert to the sql view. Compare a successful sql view view with what you're doing.

Similarly build your query in the qbe frame and run it, then run it in the sql view to see what you get.

The problem is something simple.