Multi-column Report troubles

[Digger442]

I am having trouble with a multicolumn report. I have tried to follow the directions in the Help file, but to no avail.

I am dealing with patient Lab values on multiple dates.

I have it set up with a Report header, which works fine. In the detail section, which I understand is the width of one column as determined by the the Page Setup, Columns function, I have two columns of labels on the left side (Lab names and normal ranges). Within the Details section I have a subreport which contains the controls for the lab values. The lab date is the control which determines the column.

The Report works fine EXCEPT that the number of lab value columns within the subreport determines the number of pages in the report. 3 columns, 3 pages; 8 columns, 8 pages. All pages are identical (except, of course, the Report Header which only occurs on the first page). All pages have the same columns of data.

I have tried numerous ways to fix this. I have tried putting the controls in the main report, not a subreport....I have tried putting the labels in a page header and the values in the details section of the main report and that caused the values to print out below the labels....

What am I missing??????

Thanks!!

 

[bjackson]

can you post me the report,its hard to understand
your question

 

[Digger442]

It would be easier to e-mail you a copy. I have tried to save a decent copy of it in a text file, but it isn't a good facsimile.

E-mail your address to digger442@yahoo.com and I'll send the .doc file.

Thanks much!

 

[Pat Hartman]

The query for the main report should NOT reference the tables in the many-side of the relationship.

 

[Digger442]

Pat,

You're a genuis! That worked perfectly! I've got some other pieces to work out now, but that solved the multiple pages.

The difference between one who truly understands database design/theory, and who screws around with it 'til it works!

Greatly Appreciated!

 

[Pat Hartman]

Actually, I've had 30 years to make lots of stupid mistakes including this one.