By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,471 Members | 2,277 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,471 IT Pros & Developers. It's quick & easy.

Access Report

P: 5
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?
Jan 5 '08 #1
Share this Question
Share on Google+
8 Replies


ADezii
Expert 5K+
P: 8,597
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?
Jan 6 '08 #2

P: 5
I could send you the report and the query that it uses. The database tables are all linked to sql.
Jan 7 '08 #3

jaxjagfan
Expert 100+
P: 254
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.
Jan 7 '08 #4

P: 5
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.
Jan 7 '08 #5

ADezii
Expert 5K+
P: 8,597
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.
Jan 8 '08 #6

P: 5
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
Jan 8 '08 #7

ADezii
Expert 5K+
P: 8,597
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.
Jan 8 '08 #8

P: 5
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.
Jan 8 '08 #9

Post your reply

Sign in to post your reply or Sign up for a free account.