Printing Invoices

[Jack K.]

I am trying to print all invoices with a balance due of
greater than zero. I created a table in which I enter
individual amounts due and amounts paid by my customers. I
have also created an invoice report that prints out as
line items, all amounts due and amounts paid grouped by
customer. The report includes calculated summary fields
for the total amount due and the total amount paid. The
record source for the report is a query which includes an
expression which subtracts the total amounts paid from the
total amounts due. That expression is included on the
report as a "balance due" field. In the query, I have set
the criteria for the expression as >0. My problem is this:
When no payments have yet been made to a customer's
account, an invoice does not print for that customer. Only
customers that have made at least one payment and whose
balance due is greater than zero, end up printing. I think
the problem has to do with the sum of the total amounts
paid being null, but I'm not sure. Any help would be
greatly appreciated.

 

[Dennis Schmidt]

Hi ,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

The calculation in your query needs to account for the null values. An
expression like the following turns the null values into a 0 so the
calculation will return a value.

IIf(IsNull([AmtPaid]),0,[AmtPaid])+[AmtDue]

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support