Change to report code needed


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

Advertisements

B

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
 
J

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?
 
Ad

Advertisements

B

Bob Vance

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


Top