473,320 Members | 1,865 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Report: 2 Invoices in the same page

Dear all,

I am stuck in the following problem:

.. I have an A4 paper size in landscape mode to print 2 invoices, one
on the left middle and next on the right middle.
.. Designing the report with 2 columns I can print that with no
problem.

.... but

.. I don't know how to achieve it when the left invoice has more detail
lines than fit and then I must continue printing the same invoice on
the right side
.... or when the right invoice has more details lines than fit and then
I must continue printing the same invoice on left side "but" in next
sheet of paper.

I would appreciate your comments and, if it is possible, a place where
to get a mdb with an example (I am using Access 97).

Regards.

Angel.
Nov 13 '05 #1
1 1675
amazo wrote:
Dear all,

I am stuck in the following problem:

. I have an A4 paper size in landscape mode to print 2 invoices, one
on the left middle and next on the right middle.
. Designing the report with 2 columns I can print that with no
problem.

... but

. I don't know how to achieve it when the left invoice has more detail
lines than fit and then I must continue printing the same invoice on
the right side
... or when the right invoice has more details lines than fit and then
I must continue printing the same invoice on left side "but" in next
sheet of paper.

I would appreciate your comments and, if it is possible, a place where
to get a mdb with an example (I am using Access 97).


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can use the File > Print Setup menu items to set the report to print
in 2 columns. Under the Columns tab select Down, then Across.

There is a report samples db available from MS that shows how to do
multiple column reports:

http://support.microsoft.com/default...b;en-us;231851

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQbI9iIechKqOuFEgEQLE4wCg8XkwhNftSnNMeuFysK98AO O5NaUAn3qP
M404+OrmaHDzHtHFLyc+SoHI
=9FGV
-----END PGP SIGNATURE-----
Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: David B | last post by:
I have a report with 2 sub reports on it. The report is an invoice and the sub reports are dropping data onto the invoice. This worked fine if generating 1 invoice at a time. I am trying to create...
1
by: steven | last post by:
I am creating some financial reports in Access 2000, and I am having problem that I can't resolve. The report sorts information first by vendor, then by budget line number. It generates the...
9
by: itmags | last post by:
I need to create a couple of reports, invoices, credit reports, etc... My question is: How/what is the best way to go about this using VB2005 / SQL Server 2000 Crystal Reports? MS Reporting?...
4
by: sohendalski | last post by:
I have a report "Billing Period" and it runs off of 5 small queries "InvoiceQuery", "AdminQuery", "ProjManQuery", "InspectionQuery" and "ExpensesQuery". The InvoiceQuery has the information...
4
by: mikeDA | last post by:
I have an invoice report in Access. I have three invoices. I want to force a page break after each invoice# so I end up with three invoices, each with a header (invoice# date etc.), detail (items...
4
by: Ron | last post by:
Hi All, I've got a client/transaction type of database where tblClient is linked to tblTransactions via ClientID. The client table contains all clients from day one. The transaction table...
2
by: gazsharpe101 | last post by:
Hi everyone, I am creating a query that shows a list of all invoices raised in the last month which shows the date on which they were raised along with the amounts. Each invoices has it's own ID,...
12
by: Studiotyphoon | last post by:
Hi, I have report which I need to print 3 times, but would like to have the following headings Customer Copy - Print 1 Accounts Copy - Print 2 File Copy -Print 3 I created a macro to...
5
by: msrobotto | last post by:
Past Due Boxes: 30/60/90/etc Hi! I am working on creating an Accounts Receivable database, and I want to be able to automatically generate statements for my customers. The statements need to list...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.