Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Phone List

Discussion in 'Information Technology' started by HJP84, Jul 28, 2006.

Tags:
  1. HJP84

    HJP84
    Expand Collapse
    Guest

    I am making a table in Access to store employee contact information. I was
    wondering if there is a way to extraxt a phone list from the main table. I
    only want to use the fields "last name", "first name", "phone", and
    "station".

    I tried using a "report" but the result was not exactly what I am looking
    for. I need a 1 page reference sheet with everyone's phone number that can
    be distributed easily. There are 150 records but they should be able to fit
    on one page if in multiple columns. I know this can be done in Excel but I
    wanted to have everything run from Access.

    Thanks
    -Harris
     
  2. Loading...

    Similar Threads Forum Date
    Canada Farm's phone ringing off hook with offers of help Breaking News Aug 17, 2013
    Smartphone pictures pose privacy risks Information Technology Aug 14, 2013
    India India sets up elaborate system to tap phone calls, e-mail Breaking News Jun 20, 2013
    USA NSA has massive database of Americans' phone calls (USA Today 5.11.2006) Breaking News Jun 11, 2013
    Legal US Spy Chief Defends PRISM & Phone Surveillance (No Protections in India) Breaking News Jun 7, 2013

  3. Sarah Schreffler

    Sarah Schreffler
    Expand Collapse
    Guest

    I need to work on the same thing for our Admin staff.

    I haven't had a chance yet. But I do know Access reports can do
    multiple columns.
    There's more information available at: Microsoft Office Online:
    Multiple Column Reports
    (http://office.microsoft.com/en-us/assistance/HA011565341033.aspx)
    (How do others get links in their posts?)

    Sarah Schreffler

    HJP84 wrote:
    > I am making a table in Access to store employee contact information. I was
    > wondering if there is a way to extraxt a phone list from the main table. I
    > only want to use the fields "last name", "first name", "phone", and
    > "station".
    >
    > I tried using a "report" but the result was not exactly what I am looking
    > for. I need a 1 page reference sheet with everyone's phone number that can
    > be distributed easily. There are 150 records but they should be able to fit
    > on one page if in multiple columns. I know this can be done in Excel but I
    > wanted to have everything run from Access.
    >
    > Thanks
    > -Harris
     
  4. Rick B

    Rick B
    Expand Collapse
    Guest

    Just change your report to a two column report (or three) or modify the font
    size, etc.

    You can pretty much lay out the report any way you want. Use the HELP
    feature or the REPORT WIZARD if you need help building the report.

    Post back if you need more help.

    --
    Rick B



    "HJP84" <HJP84@discussions.microsoft.com> wrote in message
    news:2B17887A-242B-4860-BEA7-E5E6EF0ED60C@microsoft.com...
    >I am making a table in Access to store employee contact information. I was
    > wondering if there is a way to extraxt a phone list from the main table.
    > I
    > only want to use the fields "last name", "first name", "phone", and
    > "station".
    >
    > I tried using a "report" but the result was not exactly what I am looking
    > for. I need a 1 page reference sheet with everyone's phone number that
    > can
    > be distributed easily. There are 150 records but they should be able to
    > fit
    > on one page if in multiple columns. I know this can be done in Excel but
    > I
    > wanted to have everything run from Access.
    >
    > Thanks
    > -Harris
     

Share This Page