Help with Dcount and grouping please

[GtiVr6]

Hi, I think I found the answer here in the following thread: thread181-27567

The situation seems the same to me, I want to page break when I hit 8 records in my sub report and then continue on the next page. I tried the example code left and when I run the SQL to get the GroupNum the results all show the same number in GroupNum so it looks like one big group. Or I'm just lost. I'm looking for some help to find a way for my sub report (or main report) to recognize that 8 records have been printed and then contiunue on a new page. Any help would be great.

Thanks.

 

[GtiVr6]

Sorry, I linked the wrong thread - bad day =)

thread703-1374544

 

[lameid]

Bad day indeed, we can't help you fix your version without seeing it...

What does your SQL look like?

 

[GtiVr6]

Actually I managed to get this all to work yesterday. I was using some code posted by Duane but I could not get the rights results. So I went back and broke the main tables down even more granular like tried to model them after the way the Northwind DB example was. And bang, the code worked, I added some grouping and forced a page break and now the report is quite slick and getting a lot of nod's from the people that matter. To be truthful, I'm only understanding 95% of the code and I can't see the big change in the table structure (there were no relationship changes) but it worked so I'm leaving it at that. If you look at the post I reference in my short reply you will see the code, Duane posted it in there, my fields and table names are different that's all.

Thanks for the reply though.