RE: Address books

I don't know which version of Access you are using so don't create the Alpha
field. Set the first level of sorting and grouping to:
=Left([LastNameField],1)
Display the group header/footer so you set properties to new page after a
group.

Set the second level of sorting and grouping to:
=[LastNameField] & [FirstNameField]

--
Duane Hookom
Microsoft Access MVP


"LOAMA" wrote:

I set the sorting and grouping two ways, once to the "Alpha" field, a single
letter and the second time to the field "Last name". Both didn't work. What
I didn't do is select the first X number of characters. Where do you do that
and what is the first X number of characters. Sorry if I sound dense.
--
Thanks for your help in advance,
LOAMA


"Duane Hookom" wrote:

You can set the sorting and grouping to a field and then select the first X
number of characters. You would then have to set another sorting and grouping
level to the full field so the records sort correctly within the primary
group/level.

--
Duane Hookom
Microsoft Access MVP


"LOAMA" wrote:

I am designing my own address book using Access 2007. The form is fine and
getting a print preview on the size paper I am using is also working. The
problem I have is that the preview does not show the addresses in
alphabetical order. I have tried using "group" or "sort" and obviously
incorrectly because that still doesn't work. I have set up a field, "alpha"
which is a single letter for each person. (The first letter of the last
name.) I also would like a page break after each letter of the alphabet. I
need help in getting the addresses in alpha order and having a new page for
the start of a new letter.
--
Thanks for your help in advance,
LOAMA
.

Relevant Pages

  • RE: Address books
    ... You said "Sorting and Grouping" together. ... "Duane Hookom" wrote: ... Microsoft Access MVP ... I didn't do is select the first X number of characters. ...
    (microsoft.public.access.reports)
  • RE: Address books
    ... I set the sorting and grouping two ways, once to the "Alpha" field, a single ... I didn't do is select the first X number of characters. ... "Duane Hookom" wrote: ...
    (microsoft.public.access.reports)
  • Re: Sorting Problem
    ... I would not consider this sorting behaviour a "bug". ... Microsoft Access MVP ... sorted by [DBxInst], because the value of DBxInst is WRONG. ...
    (microsoft.public.access.reports)
  • Re: Clean Numbers/Text
    ... Microsoft Access MVP ... I need to get rid of the dots dashes and slashes so ... all I have left are the numeric and alpha chearacters. ...
    (microsoft.public.access.queries)
  • Re: Number Issue
    ... The behaviour you describe is consistent with sorting "text" ... Doug Steele, Microsoft Access MVP ... I can get them to ascend and descend in the proper order but only the number column changes fields, the rest stay where they are. ...
    (microsoft.public.access.gettingstarted)
Loading