Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 266
  • Last Modified:

Microsoft Access Database

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?
1 Solution
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
RPashAuthor Commented:
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.


Total Amount due: $688

Total Amount due: $688
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

      Dev_id   lot_id   Ddate    Tqty

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

Report Footer

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

G. Nagraj
RPashAuthor Commented:
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.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now