Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    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. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 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