Welcome to SPN

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

Sign Up Now!

I need everyting in one row in a report

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

  1. pompeyjim

    pompeyjim
    Expand Collapse
    Guest

    I’ve designed a database which prints out permits for contractors. It also
    needs to print out a weekly log sheet to show details of each permit. The log
    sheet printout consists of several columns including: User, Application_No,
    Location, Mon, Tues, Weds, Thurs, Fri, Sat, Sun and a couple of columns that
    will need formulae in them. Each permit is valid for 12 hrs only and has a
    serial number that has to be recorded in the log sheet under the weekday
    column headings. So if a job was to last for 24hrs there would be two permits
    with the same ApplicationNo say 001 but the SerialNo would be different for
    each permit IE: ApplicationNo 001 SerialNo 123 and ApplicationNo 001 SerialNo
    345. My problem is that the log sheet printout must have the ApplicationNo in
    only one row and the serial numbers in the same row under the weekday column
    headings.

    Below is the printout I want

    User AppNo Location MonSerialNo TuesSerialNo WedsSerialNo etc
    Acme 001 Roof 123 456

    Below is the printout I’m getting

    User AppNo Location MonSerialNo TuesSerialNo WedsSerialNo etc Acme
    001 Roof 123
    Acme 001 Roof 345
    I have several tables including: tblPermitNo with: PermitNo (this doesn’t
    need to be in any printouts and is an Autonumber and is the primary key),
    DateOfIssue, DateOfExpiry, TimeOfIssue, and TimeOfExpiry. A table tblColdWork
    with: PermitID (foreign key), Location, Description etc etc and tblHotWork
    with almost the same fields (except for a few variations) as the tblColdwork
    table. Both tblColdWork and tblHotWork are on a One to One relationship with
    tblPermitNo. I also have a table tblDaysOfTheWeek with: PermitNo (foreign
    Key), Mon, Tues, Weds etc and SerialNo field in it. So my question, after
    all that, is how do I get it to printout like the first one above?
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News WWI Sikh Heroes Need To Be Remembered: Dr Atamjit Breaking News Sep 11, 2016
    Interracial And Interfaith Marriage, Help Needed To Confront/convince My Parents Love & Marriage Aug 16, 2016
    Sikh News Sikh Seva Volunteers Keep The Food Service Drive For The Needy Going After Passing Away Of Breaking News Jul 29, 2016
    Need some info regarding bibek wrt eating Sikh Rehat Maryada Jan 14, 2016
    Spiritual Why We Only Need To Pray For Naam Blogs Dec 20, 2015

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    pompeyjim wrote:
    > I've designed a database which prints out permits for contractors. It
    > also needs to print out a weekly log sheet to show details of each
    > permit. The log sheet printout consists of several columns including:
    > User, Application_No, Location, Mon, Tues, Weds, Thurs, Fri, Sat, Sun
    > and a couple of columns that will need formulae in them. Each permit
    > is valid for 12 hrs only and has a serial number that has to be
    > recorded in the log sheet under the weekday column headings. So if a
    > job was to last for 24hrs there would be two permits with the same
    > ApplicationNo say 001 but the SerialNo would be different for each
    > permit IE: ApplicationNo 001 SerialNo 123 and ApplicationNo 001
    > SerialNo 345. My problem is that the log sheet printout must have the
    > ApplicationNo in only one row and the serial numbers in the same row
    > under the weekday column headings.
    >
    > Below is the printout I want
    >
    > User AppNo Location MonSerialNo TuesSerialNo WedsSerialNo
    > etc Acme 001 Roof 123 456
    >
    > Below is the printout I'm getting
    >
    > User AppNo Location MonSerialNo TuesSerialNo WedsSerialNo etc
    > Acme 001 Roof 123
    > Acme 001 Roof 345
    > I have several tables including: tblPermitNo with: PermitNo (this
    > doesn't need to be in any printouts and is an Autonumber and is the
    > primary key), DateOfIssue, DateOfExpiry, TimeOfIssue, and
    > TimeOfExpiry. A table tblColdWork with: PermitID (foreign key),
    > Location, Description etc etc and tblHotWork with almost the same
    > fields (except for a few variations) as the tblColdwork table. Both
    > tblColdWork and tblHotWork are on a One to One relationship with
    > tblPermitNo. I also have a table tblDaysOfTheWeek with: PermitNo
    > (foreign Key), Mon, Tues, Weds etc and SerialNo field in it. So my
    > question, after all that, is how do I get it to printout like the
    > first one above?


    How is it printing different that you want?



    --
    Joseph Meehan

    Dia duit
     
  4. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    pompeyjim wrote:
    > I've designed a database which prints out permits for contractors. It
    > also needs to print out a weekly log sheet to show details of each
    > permit. The log sheet printout consists of several columns including:
    > User, Application_No, Location, Mon, Tues, Weds, Thurs, Fri, Sat, Sun
    > and a couple of columns that will need formulae in them. Each permit
    > is valid for 12 hrs only and has a serial number that has to be
    > recorded in the log sheet under the weekday column headings. So if a
    > job was to last for 24hrs there would be two permits with the same
    > ApplicationNo say 001 but the SerialNo would be different for each
    > permit IE: ApplicationNo 001 SerialNo 123 and ApplicationNo 001
    > SerialNo 345. My problem is that the log sheet printout must have the
    > ApplicationNo in only one row and the serial numbers in the same row
    > under the weekday column headings.
    >
    > Below is the printout I want
    >
    > User AppNo Location MonSerialNo TuesSerialNo WedsSerialNo
    > etc Acme 001 Roof 123 456
    >
    > Below is the printout I'm getting
    >
    > User AppNo Location MonSerialNo TuesSerialNo WedsSerialNo etc
    > Acme 001 Roof 123
    > Acme 001 Roof 345
    > I have several tables including: tblPermitNo with: PermitNo (this
    > doesn't need to be in any printouts and is an Autonumber and is the
    > primary key), DateOfIssue, DateOfExpiry, TimeOfIssue, and
    > TimeOfExpiry. A table tblColdWork with: PermitID (foreign key),
    > Location, Description etc etc and tblHotWork with almost the same
    > fields (except for a few variations) as the tblColdwork table. Both
    > tblColdWork and tblHotWork are on a One to One relationship with
    > tblPermitNo. I also have a table tblDaysOfTheWeek with: PermitNo
    > (foreign Key), Mon, Tues, Weds etc and SerialNo field in it. So my
    > question, after all that, is how do I get it to printout like the
    > first one above?


    OK now I read the message again. Ignore the prior message.

    First make sure the it is defaulted to landscape printing to give you
    some more room. Now in design mode, open the report and move all the
    controls onto a single line. Is that it?

    --
    Joseph Meehan

    Dia duit
     
  5. pompeyjim

    pompeyjim
    Expand Collapse
    Guest

    Firstly thanks for your time Joseph it's very much appreciated.

    I have all the controls on one line but you've given me an idea which might
    just work so I'm going to try it. I'll let you know how I get on.

    Thanks again.
    "Joseph Meehan" wrote:

    > pompeyjim wrote:
    > > I've designed a database which prints out permits for contractors. It
    > > also needs to print out a weekly log sheet to show details of each
    > > permit. The log sheet printout consists of several columns including:
    > > User, Application_No, Location, Mon, Tues, Weds, Thurs, Fri, Sat, Sun
    > > and a couple of columns that will need formulae in them. Each permit
    > > is valid for 12 hrs only and has a serial number that has to be
    > > recorded in the log sheet under the weekday column headings. So if a
    > > job was to last for 24hrs there would be two permits with the same
    > > ApplicationNo say 001 but the SerialNo would be different for each
    > > permit IE: ApplicationNo 001 SerialNo 123 and ApplicationNo 001
    > > SerialNo 345. My problem is that the log sheet printout must have the
    > > ApplicationNo in only one row and the serial numbers in the same row
    > > under the weekday column headings.
    > >
    > > Below is the printout I want
    > >
    > > User AppNo Location MonSerialNo TuesSerialNo WedsSerialNo
    > > etc Acme 001 Roof 123 456
    > >
    > > Below is the printout I'm getting
    > >
    > > User AppNo Location MonSerialNo TuesSerialNo WedsSerialNo etc
    > > Acme 001 Roof 123
    > > Acme 001 Roof 345
    > > I have several tables including: tblPermitNo with: PermitNo (this
    > > doesn't need to be in any printouts and is an Autonumber and is the
    > > primary key), DateOfIssue, DateOfExpiry, TimeOfIssue, and
    > > TimeOfExpiry. A table tblColdWork with: PermitID (foreign key),
    > > Location, Description etc etc and tblHotWork with almost the same
    > > fields (except for a few variations) as the tblColdwork table. Both
    > > tblColdWork and tblHotWork are on a One to One relationship with
    > > tblPermitNo. I also have a table tblDaysOfTheWeek with: PermitNo
    > > (foreign Key), Mon, Tues, Weds etc and SerialNo field in it. So my
    > > question, after all that, is how do I get it to printout like the
    > > first one above?

    >
    > OK now I read the message again. Ignore the prior message.
    >
    > First make sure the it is defaulted to landscape printing to give you
    > some more room. Now in design mode, open the report and move all the
    > controls onto a single line. Is that it?
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     
  6. Marcin

    Marcin
    Expand Collapse
    Guest

    U¿ytkownik "pompeyjim" <pompeyjim@discussions.microsoft.com> napisa³ w
    wiadomo¶ci news:3137636C-E593-44FF-8F3B-6584093973A8@microsoft.com...
    > I've designed a database which prints out permits for contractors. It also
    > needs to print out a weekly log sheet to show details of each permit. The

    log
    > sheet printout consists of several columns including: User,

    Application_No,
    > Location, Mon, Tues, Weds, Thurs, Fri, Sat, Sun and a couple of columns

    that
    > will need formulae in them. Each permit is valid for 12 hrs only and has a
    > serial number that has to be recorded in the log sheet under the weekday
    > column headings. So if a job was to last for 24hrs there would be two

    permits
    > with the same ApplicationNo say 001 but the SerialNo would be different

    for
    > each permit IE: ApplicationNo 001 SerialNo 123 and ApplicationNo 001

    SerialNo
    > 345. My problem is that the log sheet printout must have the ApplicationNo

    in
    > only one row and the serial numbers in the same row under the weekday

    column
    > headings.
    >
    > Below is the printout I want
    >
    > User AppNo Location MonSerialNo TuesSerialNo WedsSerialNo etc
    > Acme 001 Roof 123 456
    >
    > Below is the printout I'm getting
    >
    > User AppNo Location MonSerialNo TuesSerialNo WedsSerialNo etc

    Acme
    > 001 Roof 123
    > Acme 001 Roof 345
    > I have several tables including: tblPermitNo with: PermitNo (this doesn't
    > need to be in any printouts and is an Autonumber and is the primary key),
    > DateOfIssue, DateOfExpiry, TimeOfIssue, and TimeOfExpiry. A table

    tblColdWork
    > with: PermitID (foreign key), Location, Description etc etc and tblHotWork
    > with almost the same fields (except for a few variations) as the

    tblColdwork
    > table. Both tblColdWork and tblHotWork are on a One to One relationship

    with
    > tblPermitNo. I also have a table tblDaysOfTheWeek with: PermitNo (foreign
    > Key), Mon, Tues, Weds etc and SerialNo field in it. So my question, after
    > all that, is how do I get it to printout like the first one above?
    >

    ===========================================================================
    FULL LEGAL SOFTWARE !!!
    Games, video, program, image, chat, questbook, catalog site, arts, news,
    and...
    This site it is full register and legal software !!!
    Please download and you must register software !!!

    PLEASE REGISTER SOFTWARE:
    http://www.webteam.gsi.pl/rejestracja.htm
    DOWNLOAD LEGAL SOFTWARE:
    http://www.webteam.gsi.pl

    Full question and post: http://www.webteam.gsi.pl

    Contact and service and advanced technology:
    http://www.webteam.gsi.pl/kontakt.htm
    FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm

    Please add me URL for you all site and search engines and best friends !!!

    Me site:
    SERWIS WEBNETI: http://www.webneti.gsi.pl
    PORTAL WEBTEAM:http://www.webteam.gsi.pl
    LANGUAGE: http://www.webneti.cjb.net

    ==========================================================================
     

Share This Page