Access Report

[brandnewman]

I have a access 97 report that skips a record when it goes to a new page. The recordset contains two columns, column 1 works perfect and is on every page but column 2 skips one record when it goes to a new page. column1 is a name and column 2 is a sales figure. so after the first page the name and sales do not match. On the last page the last few names have all the same sales. Any ideas?

[ADezii]

I have a access 97 report that skips a record when it goes to a new page. The recordset contains two columns, column 1 works perfect and is on every page but column 2 skips one record when it goes to a new page. column1 is a name and column 2 is a sales figure. so after the first page the name and sales do not match. On the last page the last few names have all the same sales. Any ideas?

Would you be willing to send me the Database as an E-Mail Attachment along with the Report Name causing the problem?

[brandnewman]

I could send you the report and the query that it uses. The database tables are all linked to sql.

[jaxjagfan]

I have a access 97 report that skips a record when it goes to a new page. The recordset contains two columns, column 1 works perfect and is on every page but column 2 skips one record when it goes to a new page. column1 is a name and column 2 is a sales figure. so after the first page the name and sales do not match. On the last page the last few names have all the same sales. Any ideas?

Just some thoughts ...

Check your page breaks and groupings in the report. If you are grouping by column 1 make sure you are NOT forcing a new page after section within the column 1 header.

Check your query/table that the report is based on. Make sure it is not returning extra rows and /or null values for column 2.

[brandnewman]

Just some thoughts ...

Check your page breaks and groupings in the report. If you are grouping by column 1 make sure you are NOT forcing a new page after section within the column 1 header.

Check your query/table that the report is based on. Make sure it is not returning extra rows and /or null values for column 2.

There are no groupings in the report. The query is a crosstab query. I have checked it there are no extra rows or no nulls.

[ADezii]

I could send you the report and the query that it uses. The database tables are all linked to sql.

We don't have anything to lose, do we? I'll send you my E-Mail Address in a PM.

[brandnewman]

We don't have anything to lose, do we? I'll send you my E-Mail Address in a PM.

That would be great. I was able to copy the data and setup two small tables so the query and report will work. So you will be able to test what I am talking about

[ADezii]

That would be great. I was able to copy the data and setup two small tables so the query and report will work. So you will be able to test what I am talking about

Thanks, I already sent my E-Mail address to you in a PM. I'll look at it as soon as I get a chance.

[brandnewman]

Thanks, I already sent my E-Mail address to you in a PM. I'll look at it as soon as I get a chance.

Thanks,

That looks ok .The problem is that the date in the query will change I put that in there just to test. Normally we use an access form to get the certain dates data.