Writing to a Template (1 Viewer)

[Drunkenneo]

i have to write a result of the query to the excel, which is a invoice template where i need to enter the data.

Depend on the result the template can grow in size also, here if the size grows there needs to be informatin coming on first page for eg: address in first page should not repeat in second page, second page have purly order details and footer at the end which have signatue and attestation.

Problem is data can be in 1 page, 2 pages, 3 pages ..or more

How can i achieve this task as all pages have water mark as page 1, page 2...sand so on...?

(A Sample i have attached)

 

[Drunkenneo]

Thump!!!Thump!!

 

[sensetech]

I don't think you can do that with a simple query export. You'll need to either

a) set up an Access report looking like the Excel template and using the query's data, or

b) write some VBA code to get the data from the query into the correct bits of a template-formatted Excel file.

Good luck!