Welcome to SPN

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

Sign Up Now!

Page change for each worker in my table

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

  1. macdoum

    macdoum
    Expand Collapse
    Guest

    Hello. English is not my first language. So pardon me if I'm not the
    clearest !

    I have a table that has the infos about the schedule of nurses.

    The table is like this :

    NAME / FIRTS_NAME / DATE / START_TIME / END TIME

    Every name has some workshifts.

    I made a report with the wizzard. The report lists all the workshifts
    of a person in the table.

    But how do I make the report start a new page when the person's name
    changes ?

    Or how can I have a workshifts report for each person ?
     
  2. Loading...

    Similar Threads Forum Date
    50 Or So Pages Of DG Are By Guru Gobind Singh Other Scriptures Sep 9, 2016
    Interfaith Nanak Is The Guru - Nanak Is The Lord Himself - Page 865, SGGS Interfaith Dialogues Sep 22, 2015
    Ang Safaa Panna Page? Questions and Answers May 6, 2014
    USA Over 100 pages of documents outline Sikh Temple shooting & investigation Breaking News Mar 26, 2014
    Facebook removes ads from controversial pages to avoid boycott Information Technology Jun 30, 2013

  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    This is NOT a good idea unless each person has a unique name (which they wont
    have). You should add a field to your table and make it an Autonumber field.
    Set this is your primary key.

    Bring this new field into your report and (in design view) click the
    "Deisign" line (thick grey line) and select force new page (you can select a
    number of different options.

    Another way would be to use the Sorting and Grouping option (at the top of
    the page in design view) and use the primary field. Select "keep together" at
    the bottom of the box.

    Hope this helps

    --
    Wayne
    Manchester, England.



    "macdoum" wrote:

    > Hello. English is not my first language. So pardon me if I'm not the
    > clearest !
    >
    > I have a table that has the infos about the schedule of nurses.
    >
    > The table is like this :
    >
    > NAME / FIRTS_NAME / DATE / START_TIME / END TIME
    >
    > Every name has some workshifts.
    >
    > I made a report with the wizzard. The report lists all the workshifts
    > of a person in the table.
    >
    > But how do I make the report start a new page when the person's name
    > changes ?
    >
    > Or how can I have a workshifts report for each person ?
    >
    >
     

Share This Page