RE: Address books

In 2007 you would first choose to add a group on (this will automatically
sort). Choose expression rather than a field and enter:
=Left([Your Field Name Here],1)
You can add a text box to this group header section with a control source of:
=Left([Your Field Name Here],1)

Then add a Sort By based on [Your Field Name Here].

You should now have a report that groups and sorts by the first letter of
your field and within the group the field should be sorted.

--
Duane Hookom
Microsoft Access MVP


"LOAMA" wrote:

First I am using Access 2007.
Now I am more confused than ever. You said "Sorting and Grouping" together.
I can only do one at a time. If I used group and typed
"=Left([Last Name],1)" Last Name is my field name I was asked for the
parameter value.
If I used sort and wrote the same expression as above the preview was not
in Alphabetical order. And if I tried a second sort, with the first & last
name the same expression came up as my first.

If I tried to used the table to import my field names I got syntax errors.

Then when I went to properties to display new page there was only properties
for either header or footer and neither had a place for "new page". All I
found was display after "section".
I am so confused..... Can you help?

--
Thanks for your help in advance,
LOAMA


"Duane Hookom" wrote:

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: Sorting Dates
    ... If you want to sort on the date field, it should be a date data type. ... sorting or using in calculations. ... I am trying to re-do the report as we speak. ... "Duane Hookom" wrote: ...
    (microsoft.public.access.reports)
  • Re: Change report sort order
    ... order you want to sort and set the sorting ... then make them not display later when it's working properly. ... Sorting numbers and sorting text is decidedly ... > Tom Ellison ...
    (microsoft.public.access.queries)
  • RE: Crosstab Row Sorting in Alphabetical Order
    ... Is the Rank field left or right aligned in the datasheet view? ... "Duane Hookom" wrote: ... I assume this is the sorting and grouping dialog in report design. ... I am trying to sort them in alphabetical order and keep them lined ...
    (microsoft.public.access.reports)
  • RE: Address books
    ... "LOAMA" wrote: ... trying to get the alphabetical sort? ... "Duane Hookom" wrote: ... You said "Sorting and Grouping" together. ...
    (microsoft.public.access.reports)
  • RE: Sorting & Grouping Problem
    ... When I view the query the sort is perfectly how I want it. ... "Duane Hookom" wrote: ... How do I make the GroupSort column/field my primary sorting ... in headings above every Group Sub-Category and Group Category item - instead ...
    (microsoft.public.access.reports)