Sorting using SQL query

[roboticstudent]

Hello,

Can someone write an sql query using fieldname and table to sort.

I am using the Database Connectivity Toolset and I believe I am able to query using sql but I am not sure about the syntax for sorting.

I looked it up, but I am coming up with an error when implementating it in my vi.

Thanks.

[tst]

The command for sorting is Order By. For example - Select field1, field2, field5 from T_Table, Order by field2.

[Dennis_Knutson]

Right from the Access help is:

SELECT fieldlist
    FROM table
    WHERE selectcriteria
    [ORDER BY field1 [ASC | DESC ][, field2 [ASC | DESC ]][, ...]]]

ASC is return the data in ascending order and DESC is descending order. If you are having a problem with a query, you should post the query that you are using. You can also design the query in Access, run it, and then display the SQL syntax.

[roboticstudent]

Hello,

Thanks for all the insight.

This is my Access table:

Timmy

[roboticstudent]

Hello,

Thanks for all the insight.

This is my Access table:

Timmy 

[roboticstudent]

Hello,

Thanks for all the insight.

This is my Access table:

Timmy  

[tst]

Nothing was attached.

As Dennis said, you can design the query in Access and then change the view to the SQL view to see how the query should be written. If it works, you can copy and paste the text inside LV. If it doesn't, there is probably something wrong in the way you designed it.

[roboticstudent]

Sorry for the above repeat posts. I could not erase them so...

How do I go about finding the sql query in Access?

Thanks.

[tst]

Build a query in Access (there's a wizard and you can search the help for more details). Once it's built, right clicking on it in the queries list should give you an option to see it as in an SQL format.

[roboticstudent]

Thanks for helping. I appreciate your input and time.

I have attached what I have seen and it does not show the sql query although I have done as you suggested.

I have also pasted a little of the table: jenny and the fields that I am sorting in ascending and descending order by sql.

Message Edited by roboticstudent on 03-09-2006 10:05 AM