Table Formatted Report

[Triscuit]

Almost done with my database application and getting into creating Reports to print off.

The guide I'm trying to follow as a report is as attached (Output Report).

I've made a query with all of the information that I need from my linked tables (relationship map as shown in attached files)
With data being taken from tables : field Name(Report Name)
tblAnalysisInformation: txtLabNum(Lab. Number),dateAnalyzedOn(Date Organics Analyzed)
tblSampleInformation: txtClientNumID(Sample ID), dateSampled(Sample Date)
tblAnalysisResult: numConc(Numbers in table)
tblChemicalsTested: txtName(Name of Chemicals going down)

I've been using the wizard of Access 2000/2002 to create reports but the way the report is setup with a Header/Title/Detail/Footer there seems to be no way to create a report like the guide.

The best result I've had is to group everything together and make a tabular report but that repeats a lot of information on the report.

Is there any way to create a report designed like the table given?

 

[PNGBill]

Haven't open your attachments but most often, if info is repeated, move the control to a header and have the other controls in the detail.
When in the header, it will only show once.

You can have multiply Headers.
Report Name - Report Header
labNum - Lab Header
ClientNum - Client Header