Is there a format where it will put things in alphabetical order

P

Playin in T Town

I am wanting to list my books by author and add them as I read them. Is there
a place where I can type them in and it automatically puts them in
alphabetical order for me?
 
M

Mike Labosh

I am wanting to list my books by author and add them as I read them. Is
there
a place where I can type them in and it automatically puts them in
alphabetical order for me?
Click to expand...

Make a Select Query that sorts the books on their titles, and use the query
as the RecordSource property of your form. If you are not using a form, the
query will still let you enter stuff in its datasheet view. But remember,
as you are entering titles in a "random" order, to see the alphabetical
ordered list, you will then have to click Records -> Remove Filter / Sort to
refresh the alpha-order.
 
S

Steve Schapel

Playin,

You can use a Form to enter/view the Book data. And you can make this
form based on a Query, which in turn is based on your Table, and you can
use the Query to sort the data in alphabetical order of Author.
 
Top