RE: Address books

Sorry to be so dense..
I just noticed something else in Preview report.
I have entered only 18 names so far which wuld show me about 5 pages not
separating pages in alphabetical order. In the "Preview" it shows 576 pages.
Some balnk and the list repeating over. Another thing I do not understand.
I hope you can solve my frustration/dilemna.
--
Thanks for your help in advance,
LOAMA


"LOAMA" wrote:

I am typing the expression in the box "Expression Builder". Is that correct?
Still can't figure out "ADD A TEXT BOX" but would that make a differnce in
trying to get the alphabetical sort?
--
Thanks for your help in advance,
LOAMA


"Duane Hookom" wrote:

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: Address books
    ... "LOAMA" wrote: ... trying to get the alphabetical sort? ... "Duane Hookom" wrote: ... Then when I went to properties to display new page there was only properties ...
    (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)
  • 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: 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: Sorting & Grouping Problem
    ... makes it sort alphabetically by Group Name. ... How do I make the GroupSort column/field my primary sorting ... GroupSort - Ascending and moved it to the top of the list but this just adds ... "Duane Hookom" wrote: ...
    (microsoft.public.access.reports)
Loading