Secondary sort on first name

[Ellen]

Hello,
I have a phone book that I've made via a report. A sort
has been done on the last name. Can someone tell me how
to make a secondary sort on the first name? And then a
third sort on the middle name?

I'd also like only the first initial of the middle inital
to display.

Can someone help me?

Thanks in advance,
Ellen

 

[Allen Browne]

1. Open your report in design view.

2. Open the Sorting'n'Grouping box (View menu).

3. On 3 lines, enter the fields you wish to sort by:
Last Name
First Name
Middle Name

To display just the surname and initials in a box, place a text box on the
report, and set its Control Source to:
=Trim([Last Name] & " " & Left([First Name], 1) & " " & Left([Middle Name],
1))

If you are using an existing text box, change its Name property: Access gets
confused if the text box has the same Name as a field, but it is bound to
something else.

 

[Guest]

Thanks, Allen. I neglected to mention that I'm using
Access 97. I assume what you described will work for me.

-----Original Message-----
1. Open your report in design view.

2. Open the Sorting'n'Grouping box (View menu).

3. On 3 lines, enter the fields you wish to sort by:
Last Name
First Name
Middle Name

To display just the surname and initials in a box, place a text box on the
report, and set its Control Source to:
=Trim([Last Name] & " " & Left([First Name], 1) & " " & Left([Middle Name],
1))

If you are using an existing text box, change its Name property: Access gets
confused if the text box has the same Name as a field, but it is bound to
something else.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a phone book that I've made via a report. A sort
has been done on the last name. Can someone tell me how
to make a secondary sort on the first name? And then a
third sort on the middle name?

I'd also like only the first initial of the middle inital
to display.

Can someone help me?

Thanks in advance,
Ellen

.

 

[Allen Browne]

Yes. All of that is fine in A97.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thanks, Allen. I neglected to mention that I'm using
Access 97. I assume what you described will work for me.

-----Original Message-----
1. Open your report in design view.

2. Open the Sorting'n'Grouping box (View menu).

3. On 3 lines, enter the fields you wish to sort by:
Last Name
First Name
Middle Name

To display just the surname and initials in a box, place a text box on the
report, and set its Control Source to:
=Trim([Last Name] & " " & Left([First Name], 1) & " " & Left([Middle Name],
1))

If you are using an existing text box, change its Name property: Access gets
confused if the text box has the same Name as a field, but it is bound to
something else.

I have a phone book that I've made via a report. A sort
has been done on the last name. Can someone tell me how
to make a secondary sort on the first name? And then a
third sort on the middle name?

I'd also like only the first initial of the middle inital
to display.

Can someone help me?

Thanks in advance,
Ellen