Duplicates in last two lines of each groups in my report

  • Thread starter Thread starter ShawnMao
  • Start date Start date
S

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!
 
ShawnMao said:
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.
Click to expand...


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