How to order columns in ascending order?

[darkingthereturn]

Hi!


First of all, sorry for my worst english.
My question is simple: I've got a database of my book collection. If i view it in a style sheet, it is something like

Author Title etc.
A 0
C 1
B 3
F 2
D 5
D 4
A 8
F 9

I would like to order the Author and Title columns (permanently). Particularly, I would like to order in alphabetical order all the authors and, if I've got the same author, order his/her book alphabetically, something like:

Author Title etc.
A 0
A 8
B 3
C 1
D 4
D 5
F 9

How can I achieve this? Thank you! Regards
Angelo

[R_Badger]

You should use a query for this.

Something along the lines of

SELECT * FROM [Your Table Name here] ORDER BY [AUTHOR] ASC, [TITLE] ASC

For more info on SQL statements see:
http://www.w3schools.com/sql/default.asp

[darkingthereturn]

You should use a query for this.

Something along the lines of

SELECT * FROM [Your Table Name here] ORDER BY [AUTHOR] ASC, [TITLE] ASC

For more info on SQL statements see:
http://www.w3schools.com/sql/default.asp

Thank you! I'm sorry but I really don't know where to write that command in Access 2003.
Thanks again!

Angelo

p.s: is that command permanent?

[R_Badger]

Maybe this will help
http://inpics.net/tutorials/access2003/basics39.html

[darkingthereturn]

Hi, it didn't help me
I'll explain: when my open my database in Access 2003 (catalogue.mdb) I've got a form with 2 buttons:
1) Insert
2) Search

I would like something that, when i insert a new entry, it is automatically ordered as explained before. I mean, order by author and order by title for the same author. How can I achieve this? I'll show you some screenshot if you don't understand. Thank you and sorry for my stupid questions! :S

http://i.imgur.com/Y7Xn3.jpg
In this picture you can see my "insert form"

http://i.imgur.com/7K9xj.jpg
In this picture there is a style sheet view. As you can see, the author is ordered correctly (Angelo) but the author Anger, Kenneth has multiple title disordered.

I would like something that, when i insert a new entry, it automatically order it in the correct position and, if there is the same author, it will order the title so when i click on style sheet view it is automatically ordered.
Thank you!

N.B: I don't care about ID column!!! I don't know how to use Access 2003 very well, so if possible, explain what should I click step by step. I know that is boring and frustrating to you but I appreciate your help very much. Thanks again!

[darkingthereturn]

Hi, it didn't help me
I'll explain: when my open my database in Access 2003 (catalogue.mdb) I've got a form with 2 buttons:
1) Insert
2) Search

I would like something that, when i insert a new entry, it is automatically ordered as explained before. I mean, order by author and order by title for the same author. How can I achieve this? I'll show you some screenshot if you don't understand. Thank you and sorry for my stupid questions! :S

http://i.imgur.com/Y7Xn3.jpg
In this picture you can see my "insert form"

http://i.imgur.com/7K9xj.jpg
In this picture there is a style sheet view. As you can see, the author is ordered correctly (Angelo) but the author Anger, Kenneth has multiple title disordered.

I would like something that, when i insert a new entry, it automatically order it in the correct position and, if there is the same author, it will order the title so when i click on style sheet view it is automatically ordered.
Thank you!

N.B: I don't care about ID column!!! I don't know how to use Access 2003 very well, so if possible, explain what should I click step by step. I know that is boring and frustrating to you but I appreciate your help very much. Thanks again!

Help me please! :S