If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
A-Z filtering of first names
Create a query based on the table. Arrange the columns in query design view
so that LastName is to the left of FirstName. Choose Ascending as the Sort Order for LastName and FirstName. If you like, create an additional field in the query by putting something like this at the top of a blank column: FullName: [FirstName] & " " & [LastName] or LastFirst: [LastName] & ", " & [FirstName] You could add both fields, depending on your needs. Now on a form or report you can select FullName or LastFist as the Control Source of a text box. "pamay" wrote in message news OK I have my 7,000 name index sorted by surname, say Smith, now I cant figure out how to sort first names from Anne Smith to Zeta Smith. Please help, thanks Patricia May -- pamay |
#2
|
|||
|
|||
A-Z filtering of first names
OK I have my 7,000 name index sorted by surname, say Smith, now I cant figure out how to sort first names from Anne Smith to Zeta Smith. Please help, thanks
Patricia May |
Thread Tools | |
Display Modes | |
|
|