Secondary sort on first name

  • Thread starter Thread starter Ellen
  • Start date Start date
E

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
 
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.
 
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
Click to expand...


.
Click to expand...
 
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top