Duplicates in last two lines of each groups in my report

[ShawnMao]

HI,

I am new to ACCESS with other programming experience.
I have to maintain a ACCESS report to run it with quaterly data updates.
After I imported the q2 2009 data and run the report, I have duplicates (the
last two lines for each sub group for all the raws). I can see them in the
Layout View, but I do not know how to delete them. I go to check the Visual
Basic code and could not find where these duplicate are defined. Thank you in
advance!

 

[Marshall Barton]

I am new to ACCESS with other programming experience.
I have to maintain a ACCESS report to run it with quaterly data updates.
After I imported the q2 2009 data and run the report, I have duplicates (the
last two lines for each sub group for all the raws). I can see them in the
Layout View, but I do not know how to delete them. I go to check the Visual
Basic code and could not find where these duplicate are defined.

Always check this kind of thing in Previre, not layout.

If the dupolicates appear in Preview, then either there
really are duplicate data records in the table, the report's
record source query is doing something odd or the report's
group footer has the same set of controls as the detail
section.