I need everyting in one row in a report

G

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?
 
J

Joseph Meehan

pompeyjim said:
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?
Click to expand...

How is it printing different that you want?
 
J

Joseph Meehan

pompeyjim said:
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?
Click to expand...

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?
 
G

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.
 
M

Marcin

U¿ytkownik "pompeyjim said:
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?
Click to expand...
===========================================================================
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

==========================================================================
 
Top