how do i automatically set payment amount to say zero?

  • Thread starter Arvin Meyer [MVP]
  • Start date
A

Arvin Meyer [MVP]

You can set the report to have a recordsource of a query, with the
Customer's table joined to the invoice and payment tables with an Outer Join
(I.e. All customers and whicher invoices and payments that match)

Add columns like:

Inv: CCur(NZ([InvoiceDetails],0))

and
Pmt: CCur(NZ([PaymentDetails],0))

Those columns will now display the values if they exist, and a £0.00 if they
do not.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
L

Louisec17

my database has invoice details & payment details linked, but the amount owed
report does not recognise customers who have paid nothing! the payment form
must have a payment of £0.00 entered for this to work...how can i set this to
happen automatically??
thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AR Aging - When Pymts are Applied to Acct vs to Invoices 0
How do I edit records shown in a form? 0
Overflow from Calculation - How do I do Calculation? 10
how do i get attachments to appear on my sent items 0
how do i set up a "balance over 30 days" field in an invoice? 1
how do I set up or adjust my column chart? 0
how do I set up or adjust my column chart? 2
how do I set up a customer list to track payments 1

Top