RE: Address books

You really seem to be struggling with this. I would work only in design view
since that is where I am most comfortable with the display.

When you add a Grouping level, this creates a group section in your report
design. The horizontal bar you referred to is the visual divider between
report sections. You might have these for
-Report Header
-Page Header
-Group Headers
-Detail
-Group Footers
-Page Footer
-Report Footer
You can add controls to each of these sections by clicking a control and
then clicking in the section where you want the control.

If you are getting too many pages, then either you have too many records in
your report's record source or your sections (see above) are much taller than
they need to be.

If you can find your report properties, it might be good to copy the Record
Source sql view and paste it into a reply to the news group.
--
Duane Hookom
Microsoft Access MVP


"LOAMA" wrote:

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: ... You said "Sorting and Grouping" together. ...
    (microsoft.public.access.reports)
  • RE: Address books
    ... trying to get the alphabetical sort? ... "Duane Hookom" wrote: ... You said "Sorting and Grouping" together. ... Then when I went to properties to display new page there was only properties ...
    (microsoft.public.access.reports)
  • RE: Address books
    ... Then add a Sort By based on. ... You said "Sorting and Grouping" together. ... Then when I went to properties to display new page there was only properties ... "Duane Hookom" wrote: ...
    (microsoft.public.access.reports)
  • Re: Sorting by Month
    ... > You can include both the number and the month name in your report. ... Sort by ... > the numeric and display the month name. ... > Duane Hookom ...
    (microsoft.public.access.reports)
  • Re: Sort order - Data midified / Created
    ... Under "Date formats" there is a drop down menu that you click called "Short date:" it is here you can choose the format you would like to have your dates display in. ... you can change or add many different heading in columns to view and sort the different properties that different apps will let you set when you fill in the fields in the properties sheet for the file you have created and or add your own Custom properties if allowed depending on the application. ... That being said there are many ways you can display the information about files and folders from within Windows Explorer from Stacking, filtering, grouping and using the search box at the top of Windows Explorer. ... Open control panel type "Folder options" in the dialog that opens under the search tab check the box next to use natural language search. ...
    (microsoft.public.windows.vista.general)