?
Solved

Microsoft Access Database

Posted on 2003-03-03
5
Medium Priority
?
265 Views
Last Modified: 2010-04-17
I have an Access 97 database for producing Bill of Ladings & Invoices. I'm reconfiguring the invoice layout. And whenever I place the "total amount" line in the Details section. Access will print out 2 copies of my invoice. Is there a setting somewhere I can check to tell Access to only print 1 copy only?
0
Comment
Question by:RPash
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 

Expert Comment

by:simonfinn
ID: 8059618
Hi RPash

I need a little more information about your database.  Firstly are the 2 copies identical?  Also did this happen before you changed the layout, if so what have you changed?

Cheers Si
0
 
LVL 1

Author Comment

by:RPash
ID: 8060747
The 2 copies are identical. The duplication only occurs when I input a field in the "Details" on my report. The fields are the total sum of the product amounts, the break-down of who the items are coming from and how much they are costing us, when it was requested, when it was shipped and who it was shipped to. If I only insert the "total amount due" field into the detail tab, it prints out 2 copies of the amount due on the printout.

i.e

Total Amount due: $688


Total Amount due: $688
0
 
LVL 1

Expert Comment

by:yossigordin
ID: 8063105
Hi RPash,
If tou want to see the total amount, you should make this text box not in the detail section, rather in the footer of your object.for example if you have a layout like this:

Report Header:

Device Header:
      Device    lot      date     qty

Detail:
      Dev_id   lot_id   Ddate    Tqty

Device Footer:
 Total for Device: Dev_id         =sum([Tqty])

Report Footer

Regards,
yossigordin
0
 
LVL 1

Accepted Solution

by:
nagviv earned 800 total points
ID: 8063178
Hi Rpash,

You should place your 'grand totals" in footer sections (Page footer). If on the other hand you want the grand total to be the total of all sums then place the text box(the calculated field) on the report footer
Regards,

G. Nagraj
0
 
LVL 1

Author Comment

by:RPash
ID: 8064387
Well the page footer would have worked, but the problem arises because the placement of the grand total is too high up (7.5 inches down the paper, "9.5 x 11") so the page footer doesn't reach high enough. I ended up placing it on the report footer which does the job. Only catch would be is if they want a total on every page, the report footer would list the amount at the end of the report. Luckily they only print 1 page for each invoice.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
Introduction to Processes

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question