 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / May 2008pagebreak in queries
Hi, I have created a query of personnel info which I am exporting to Excell via a macro with OutputTo. For printouts In Excell we are going to need page breaks per departments. Is it possible to do a ForceNewPage in a query in Access. I have gone thru many of the postings but they all addressed reports. In Excell I've found a way but when I run the macro from Access to update the data it overwrites the Excell file. I need to force a new page each time the department code changes. Regards, Lupe Lupe, If you able to bring data to Excel, and want page break per department. Excel could do that for you with command Subtotal in Data pull down menu. You can select the page break for your department. If you satisfy with that, you could do the macro in Excel. >Hi, >I have created a query of personnel info which I am exporting to Excell via [quoted text clipped - 6 lines] >I need to force a new page each time the department code changes. >Regards, Lupe Hi Phil, I can do it in Excell but the only thing is that whenever I run the macro from Access it overwrites the data and the file. That's why I want to look into the possibility to do it directly in Access first and then export it to Excell with the page breaks already there. Lupe > Lupe, > [quoted text clipped - 13 lines] > >I need to force a new page each time the department code changes. > >Regards, Lupe Lupe, Sorry. I don't think there is a force page break in query of Access yet. I, however, think the report is best for your situation, or export the whole database into Excel and use criteria to extract data as in query. Good luck. >Hi Phil, >I can do it in Excell but the only thing is that whenever I run the macro [quoted text clipped - 8 lines] >> >I need to force a new page each time the department code changes. >> >Regards, Lupe |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.