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?