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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to type each letter of the alphabet automatically in a specific color in Word? 0
Open Multiple Microsoft Office Documents in Alphabetical Order from Windows Explorer. 0
using 2nd template, cant get them to auto list into alphabetical 1
Excel How to Auto-Alphabetize a Specific Range in Excel? 1
How do I put things in alphabetical order in microsoft word? 1
How to sort records in a report 4
Auto Sort 1
sort alphabetical in report 4

Back
Top