Hello,

I am having a little problem with an access report I am working on it. Basically, I am looking to produce reports for members' information on a certain date range. The weirdest thing happen and not sure how to fix this.

When I run the report, the data for "record1" displays correctly. However, after the page break, the member's name for record1 is repeated for "record2" but displays the data for record 2. It's like it's stealing record2 data. Then after the page break, the member of record2 display its name but the data for record2. This goes on till the very end of the report where the last member does not have any data.

Here's an illustration of the problem.

Table Data
John Doe 5/15/1900 5 10 20
Jane Doe 5/15/1900 6 11 40

Now the report looks like this

Member's Name: John Doe
5/15/1900 5 10 20

Member's Name: John Doe
5/15/1900 6 11 20

Member's Name: Jane Doe
[blank]

............................................


My Report Designs looks like this:

Page Header

Member's Name: _______________

Date Info1 Info2 Info3 Info4

[Member Header]



Detail
Datedata info1data info2data... etc...

Member Footer
Total sum of info1.....2....3....4 etc...
page break

Page Footer
foter content.....