Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing only Invoices with a Balance (Access 2000)

    I am trying to make a report that will print only the invoices that have an outstanding balance. The invoice lists what is on the invoice (the different lines--e.g. Elementary Fee, $35; Local Levy, $5; Agenda, $5). Then it has a Total of the lines on the invoice (e.g. $45). Then how much in total payments, and the balance due. I have a Query that shows each line of the invoice (Amount), what was paid for each line of the invoice (e.g. $30 of the Elementary Fee, $5 of the Agenda Fee), then what is remaining of each line of the invoice. The problem is...I can't figure out how to tell it that I want to just print the invoices that have a balance. Does anyone know how I can tell it to do that?

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Printing only Invoices with a Balance (Access 2000)

    I don't know the stucture of your database, so this is guesswork. You might create a Totals query based on the Invoices and InvoiceDetails tables (assuming you have something like those), with the InvID (or whatever the invoice ID is called), total amount, total payment and balance. Set the criteria to select only those InvID's whose balance is <> 0.
    Save this query.
    Add it to the query that you use for the report, and link it to the Invoices table on InvId. That should restrict your report query to the invoices that have an outstanding balance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •