problem genarating a report

[dawson321]

hi

I have a report that should show details of a job such as, customer details, start dates and materials ect.

when i open a report for a job that does not have any materials added to it yet it opens up blank.

Is there a reson for this and is there a solution?

Thanks

 

[ByteMyzer]

Yes, your JOBS table is INNER JOIN-ed to your MATERIALS table. You need to change this to a LEFT JOIN (ex. FROM [Jobs] LEFT JOIN [Materials]).