I see options in Access to sort My Book Collection by subject matter or
author, but how can I sort the database BY TITLE??

Thank you in advance for any help you have to offer.

Check this link about creating queries, and how to sort the data by a field

http://support.microsoft.com/kb/304361/EN-US/

--
\\// Live Long and Prosper \\//
BS"D


"jw" wrote:

> I see options in Access to sort My Book Collection by subject matter or
> author, but how can I sort the database BY TITLE??
>
> Thank you in advance for any help you have to offer.
>
>

I'm assuming you have a database that has been built from some kind of
sample or template. You really need to give more information, but here's a
guess that might get you going.

Say you have an option group on your form, named "opgSortBy". It had two
buttons: "Subject" (value 1) and "Author" (value 2). You need to add a
third button, "Title" (value 3).

Then find the code associated with changing the value of the option group -
it's probably in the AfterUpdate event procedure.

Maybe it looks something like this:

Private Sub opgSortBy_AfterUpdate()
Select Case opgSortBy
Case 1: Me.OrderBy = "Subject"
Case 2: Me.OrderBy = "Author"
End Select
Me.OrderByOn = True
End Sub

You need to add a third "Case" line:
Case 3: Me.OrderBy = "Title"
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

"jw" <(E-Mail Removed)> wrote in message
news:C9D5FA2C-06BF-4912-9D0F-(E-Mail Removed)...
>I see options in Access to sort My Book Collection by subject matter or
> author, but how can I sort the database BY TITLE??
>
> Thank you in advance for any help you have to offer.
>
>

Thank you, Mr. Mandeno! I GOT IT! and I apologize for failing to provide
complete information.

JacE

"Graham Mandeno" wrote:

> I'm assuming you have a database that has been built from some kind of
> sample or template. You really need to give more information, but here's a
> guess that might get you going.
>
> Say you have an option group on your form, named "opgSortBy". It had two
> buttons: "Subject" (value 1) and "Author" (value 2). You need to add a
> third button, "Title" (value 3).
>
> Then find the code associated with changing the value of the option group -
> it's probably in the AfterUpdate event procedure.
>
> Maybe it looks something like this:
>
> Private Sub opgSortBy_AfterUpdate()
> Select Case opgSortBy
> Case 1: Me.OrderBy = "Subject"
> Case 2: Me.OrderBy = "Author"
> End Select
> Me.OrderByOn = True
> End Sub
>
> You need to add a third "Case" line:
> Case 3: Me.OrderBy = "Title"
> --
> Good Luck!
>
> Graham Mandeno [Access MVP]
> Auckland, New Zealand
>
> "jw" <(E-Mail Removed)> wrote in message
> news:C9D5FA2C-06BF-4912-9D0F-(E-Mail Removed)...
> >I see options in Access to sort My Book Collection by subject matter or
> > author, but how can I sort the database BY TITLE??
> >
> > Thank you in advance for any help you have to offer.
> >
> >
>
>
>