P
pompeyjim
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?
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?