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 said:
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
:
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
:
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
:
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.