how do i automatically set payment amount to say zero?

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6688-how-do-i-automatically-set-payment.html
happen automatically??
thanks

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6688
http://www.mvps.org/access

"Louisec17" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6688
news:EA3712B2-10D7-478C-8571-584C4A717F3C@microsoft.com...
> 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