Report with subreport formats forever... 1

[TCARPENTER]

I have report with only 5 subreports. Each sub-report contains only 1 field from a table and 3 unbound check boxes and one unbound text box. They also contain labels with just text in the report header section. This is all just for grouping purposes.

The main reports query left joins 5 tables with a preliminary query joining 9 tables (containing 3 left joins).

Is it possible my queries are too complex? I am only returning 9 fields for the first query, 6 fields for the second query, and like I said earlier, each subreport is returning only one field.

Is there anything else I'm missing? The subreports are all linked to the proper Master/Child fields (the same for all).

Any ideas would be greatly appreciated!

Thanks
Todd

 

[TCARPENTER]

Forgot to mention, all the reports will run fine separately, and when I made one big query to capture all the information I needed that ran as well.

Thanks again.
Todd

 

[dhookom]

You should place your question in the text of your message so we have a clear understanding of your issue. Are you using "Page of Pages" in your main report?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[TCARPENTER]

Yes, page of pages is used.

 

[dhookom]

Try remove at least the Pages part and if that doesn't help then get rid of the entire expression.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[TCARPENTER]

Thank you Thank you...!

Sorry for the short reply earlier, I was late for a meeting.
I'll try to be clearer in the future!

Todd