Results 1 to 2 of 2
  1. #1
    PinkDuster's Avatar
    PinkDuster is offline Advanced Beginner
    Windows 7 64bit Access 2013 32bit
    Join Date
    Aug 2017
    Location
    Cleveland area
    Posts
    65

    Create Customized Invoice (Report) based on a Customer and Transaction type Parameter

    I have created a sales and inventory database which currently generates an invoice (Report) with Customer billing & shipping information plus a listing of the items purchase, quantities, extended prices, and totals.



    Now I need to create customized invoices with slightly different information based on whether the customer paid with a credit card or not, and a pick for shipping & handling type, and whether there is a special notice at the bottom of the invoice.

    Am not sure the best way to proceed. Have three separate invoice Reports, or have one Report with fields that hide or not depending on selections.

    Thank you in advance for any advice.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,898
    My vote is for one invoice report object if at all possible. Use conditional expressions in textboxes.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 05-03-2017, 02:26 PM
  2. Invoice/Customer Database
    By gebmiller1984 in forum Access
    Replies: 5
    Last Post: 01-15-2015, 04:17 PM
  3. Email Each Invoice to each customer
    By snehal0909 in forum Database Design
    Replies: 2
    Last Post: 06-12-2012, 02:27 PM
  4. Replies: 7
    Last Post: 11-14-2011, 05:59 PM
  5. Customer Invoice Strategy
    By ChuckColeman1812 in forum Database Design
    Replies: 2
    Last Post: 03-12-2011, 09:00 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums