Is it possible for a SELECT to list a Field numerically?

    Re: Is it possible for a SELECT to list a Field numerically?


    Can you qualify your question a little more, I'm not sure what you mean - the above will work of you have a table named table1

    Re: Is it possible for a SELECT to list a Field numerically?


    I want to take the whole table and with a "SELECT * FROM [table1] and something else" that sorts the data by the field and make the data printed as in the order of Field1.


    table1 is a table in an Access file that has a field in it called Field1.

    Re: Is it possible for a SELECT to list a Field numerically?


    Maybe, Something like:


    SELECT *
    FROM Table1
    ORDER BY Field1 ASC


    Though I still don't really have a clue what you're looking for

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login