Record not showing up on Report

[suz@dps]

I am using MS Access Vrsn 2. I have a report that prints out service route sheets for our field techs. I recently modifed an existing report to print in landscape format and changed it from printing one day of the week per page to no page breaks. My problem is that one of my routes is not showing up on the report. I have 7 routes and the 8th won't appear. I moved the info from the 7th route to route 1 and it shows up now. I've tried deleting and recreating the route and it still doesn't work. As you can tell, I'm not an expert at Access but have taught myself by getting into the "guts" of our Corporate program and figuring out how to modify forms, reports, etc. so I may not be explaining with enough info for someone to help me. Anyone have any ideas? Thanks in advance!

 

[jtvcs]

Sounds like you've done some valid investigation. Maybe you could attach database containing the report and subject data for one of us to try and resolve. HTH JT

 

[suz@dps]

Thank you jtvcs & Pat Hartman for your responses to my question. I've "fixed" the problem - altho' I basically "cheated" in doing so! I took another report that prints all the routes and modifed it and saved it under the report name I was having trouble with and attached the query I needed to it and this seems to have solved the 'last route not showing' problem. Actually, after reviewing the route printout more extensively this AM, I realized that the last route was printing, it was just not page breaking before it and it was appearing at the end of the route before it. All the other routes were page breaking appropriately so I have no idea why this last one wouldn't work properly. Pat, the record is auto saved after it's created so that wasn't the problem. This program is set up with all sorts of menus, forms, etc. for basically "foolproof" usage. Most of the employees who use it are not extremely computer literate. I'm the only one in the company who gets in using F11 and modifies anything! Anyway, thanks to both of you for your help.

 

[suz@dps]

Thanks!

Hi Pat - thank you for your 2nd response. I'll make a note of it in my file for future reference! Have a good day.