pagebreak in queries

L

Lupe

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
 
P

PhilT via AccessMonster.com

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.
 
L

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
 
P

PhilT via AccessMonster.com

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
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,
Click to expand...
[quoted text clipped - 13 lines]
Click to expand...
 
Top