Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Print Telephone listing (Access 97)

    I have a database with two filelds... name and telephone. Is there a example someplace that shows how to print the a directory in alphabetical order but split by alphabet? A large "A", next line all the names, phone numbers that start with "a". blank lines.... A large "B", followed by all the names that start with B.

    This is then split in to two or three columsn.

    I seem to remember someplace someone had a sample of this.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Print Telephone listing (Access 97)

    Why don't you introduce another field that happens to be the first character of the name, then introduce a grouping on this field, while sorting on this field then name.
    In the Page Setup (under File) and goto the Columns tab, you can specify the number of columns.
    HTH
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print Telephone listing (Access 97)

    I remember it also - I saw it in a Logical Operations Training manual for Access. I looked through my manuals, but it must have been before v97, because I no longer have those older ones. None the less, Patt explained how it is done. That new field uses the Left function to get the first letter of the Last Name in the group header. Format it large and bold.

  4. #4
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Print Telephone listing (Access 97)

    I thought I've seen this too, but looking thru the various sample databases MS has provided at one time or another could not find good example. I've attached small sample database I quickly devised, using Customers table from NorthWind.mdb and a similar report I had in one of my own databases, modified to work with the Northwind data. I modified the Customers table to split ContactName into first & last names, more useful for a phone listing (see update qry in attd file). Report is grouped by initial (first letter of last name) and formatted in two columns. It's kind of crude but maybe will help you get started.

    NOTE: I'm using Access XP, converted to ACC 97 format hopefully converted OK.
    Attached Files Attached Files

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Print Telephone listing (Access 97)

    The sample everyone is trying to remember is in the Solutions database under Sample Reports and the item is CustomerPhoneList. The 97 version of Access came with the Solutions.mdb, so check your disks for it. Later versions of it are available as downloads.
    Charlotte

  6. #6
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Print Telephone listing (Access 97)

    I dug out my old Office 97 CD, you're right, it's in the ..OFFICESAMPLES folder. The A2K version of the Solutions database can be downloaded from:

    Microsoft Access 2000: Building Applications with Forms and Reports

  7. #7
    Star Lounger
    Join Date
    Feb 2002
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print Telephone listing (Access 97)

    I think the telephone book you were referring to is the one found in Sal Ricciardi's PC Magazine article of 4/12/98. It prints a multi-column phone directory that has the last name fields preceded by the appropriate letter. This letter is larger and bold.
    I don't know if it is available anymore, but I have a Access 97 version I'll post with this message.
    Hope this helps,
    Doug
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •