Change to report code needed

  • Thread starter Thread starter Bob Vance
  • Start date Start date
B

Bob Vance

At Present tblInvoice.OwnerPercentAmount (owing) and
tblAccountStatus.PaidAmount (Payed)
My report will print everything that is more than zero owing, but if I have
a client in Credit say ($200.00) it will not batch print can the code be
changed so as everything but zero will print....Thanks for any help..Bob

Me.tbOverDueAmount.ControlSource = "=iif(Nz(DSum('OwnerPercentAmount',
'tblInvoice', 'OwnerID =
Reports!rptOwnerPaymentMethodBatch![tbOwnerID].[value] and InvoiceDate < #"
& Format(Form_frmMain.tbFromDate.value, "MM/dd/yyyy") & "#'), 0) -
Nz(DSum('PaidAmount', 'tblAccountStatus', 'OwnerID =
Reports!rptOwnerPaymentMethodBatch![tbOwnerID].[value] and BillDate < #" &
Format(Form_frmMain.tbFromDate.value, "MM/dd/yyyy") & "#'), 0) = 0, " _
& "'(' & Nz(DSum('OwnerPercentAmount', 'tblInvoice', 'OwnerID =
Reports!rptOwnerPaymentMethodBatch![tbOwnerID].[value] and InvoiceDate < #"
& Format(Form_frmMain.tbFromDate.value, "MM/dd/yyyy") & "#'), 0) -
Nz(DSum('PaidAmount', 'tblAccountStatus', 'OwnerID =
Reports!rptOwnerPaymentMethodBatch![tbOwnerID].[value] and BillDate < #" &
Format(Form_frmMain.tbFromDate.value, "MM/dd/yyyy") & "#'), 0) &
')',Nz(DSum('OwnerPercentAmount', 'tblInvoice', 'OwnerID =
Reports!rptOwnerPaymentMethodBatch![tbOwnerID].[value] and InvoiceDate < #"
& Format(Form_frmMain.tbFromDate.value, "MM/dd/yyyy") & "#'), 0) -
Nz(DSum('PaidAmount', 'tblAccountStatus', 'OwnerID =
Reports!rptOwnerPaymentMethodBatch![tbOwnerID].[value] and BillDate < #" &
Format(Form_frmMain.tbFromDate.value, "MM/dd/yyyy") & "#'), 0))"
 
OOPs Sorry its controlled by a query so what I need is criteria <1 & >1
just in case i have a total $0.003....Thanks Bob
 
OOPs Sorry its controlled by a query so what I need is criteria <1 & >1
just in case i have a total $0.003....Thanks Bob

No number is simultaneously greater than one and also less than one. Bob, I'm
not at all sure just WHAT you're asking! Perhaps
= 0.01 OR <= - 0.01

to find all values exceeding one cent in either direction?
 
Thanks John, Thats what i needed...Regards Bob

John W. Vinson said:
No number is simultaneously greater than one and also less than one. Bob,
I'm
not at all sure just WHAT you're asking! Perhaps


to find all values exceeding one cent in either direction?
 

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


Back
Top