Report adding top item on page twice

[artyk]

Hi. I am designing a report that is supposed to show the number of meetings for each department for each month. The department is bound to the table (that's the only way I could get it to display more than 2.5 pages). It shows 4 departments per page and then the 12 months below each department name. I have a total as a report footer with code calculating all the values for the report. What is happening is that it is adding whichever department is at the top of the page twice. I've stepped through the code and it seems to be a problem with the bound portion, not the code. I'm not sure what could be wrong, all I did was put 2 text boxes on the form (one for department name and one for department code) and set their recordsource property to the appropriate value in the table. Would anyone happen to have come across this before? I would greatly appreciate any help you could provide. Thanks.

 

[lameid]

Two questions come to mind...

1) What is your code?

2) What are you specifically trying to do?

My hunch is that you are doing something that could better be handled by grouping and summing values.

 

[artyk]

Actually, I played around with it and got it to work. Thanks for pointing me in the right direction.