RE: Address books

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
    ... I don't know which version of Access you are using so don't create the Alpha ... Set the second level of sorting and grouping to: ... Microsoft Access MVP ... I didn't do is select the first X number of characters. ...
    (microsoft.public.access.reports)
  • 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: DEFCON 16 and Hacking OpenVMS
    ... To reproduce this, apparently one is to enter exactly 511 characters ... Of course it could even be Alpha chip type ... Sampsa's report of VMS vulnerabilities in the Defcon 16 slides. ...
    (comp.os.vms)
  • Re: A new twist on the last problem (D3/NT)
    ... This synonym gave me all the alphas in the record ID so for the above ... data I got 1 to 3 alpha characters, which was great as it allowed me to ... wanted just the first alpha part before the numeric, ie R, RC, SZY. ... and the following numerics can vary, but the end alpha (after the ...
    (comp.databases.pick)
  • Re: "Dollhouse" = Duh-house
    ... But then, why does Alpha go through the trouble of having an agent, ...  Didn't this Richard pose as someone who ... characters with a bit more meat on their bones. ... I praise what's praiseworthy, I trash what's trashworty. ...
    (rec.arts.tv)
Loading