2002-11-07, 14:49 #1
- 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?
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!
+ 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!
2002-11-07, 15:05 #2
- Join Date
- Mar 2002
- 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.