Search results for query: *

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...

Hmmm, I'm still not getting very far here and I know it's something stupid that I just don't seem to get. I downloaded the Northwind DB and put your code in there and it works fine, like I want it to. Basically I want it to return to me, all client related fields for each person the report is...

I see, now I have 2 situations for this report. For the individual manager reports, the unique factor will be manager name, however in the second instance (which is the one I was working on since it returns the most records) is the senior manager report. I'll add the criteria to select based on...

Hi Duane, I've tried to do what you've asked and I'm having some trouble. I've also reviewed what you wrote in a previous thread where someone was having a similar issue and they needed to group by 10. I've added the column in the record source query to create the GroupNum however when I...

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

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...

Thanks, I'll try that and see how it goes.

Hi, sorry if this sounds too easy or stupid, I've been trying for a couple of days now to get this to work and I've read a lot on here so hopefully didn't miss anything. I have a report that basically draws fields out of a table and displays them, nothing fancy. I need it to print 8 and then...