Change to report code needed

[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))"

 

[Bob Vance]

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

 

[John W. Vinson]

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?

 

[Bob Vance]

Thanks John, Thats what i needed...Regards 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


to find all values exceeding one cent in either direction?