RPash
asked on
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?
ASKER
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
i.e
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
Detail:
Dev_id lot_id Ddate Tqty
Device Footer:
Total for Device: Dev_id =sum([Tqty])
Report Footer
Regards,
yossigordin
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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