I have a query (qryOrderData) that lists all our Orders and shows a variety
of data including InvoiceValue.
InvoiceValue is an expression that comes from another query
(qryOrderInvoices)which looks at tblInvoices and groups them by OrderNo to
give me a total that has been invoiced on each order.
Trouble is, if an order hasn't been invoiced yet it obviously isn't included
in qryOrderInvoices.
And then when qryOrderData tries to look for InvoiceValue on those orders it
doesn't find anything of course, and shows #Error.
I have tried using Nz in various ways but cannot get rid of the #Error. I
want it to show 0 in such cases.
My field is this: InvoiceValue: Expr1 (with the source being
qryOrderInvoices)
How should I modify it, please?
Many thanks
CW

Sorry, sorry! This should have been in the Access discussion group, not here
CW

"CW" wrote:

I have a query (qryOrderData) that lists all our Orders and shows a variety
of data including InvoiceValue.
InvoiceValue is an expression that comes from another query
(qryOrderInvoices)which looks at tblInvoices and groups them by OrderNo to
give me a total that has been invoiced on each order.
Trouble is, if an order hasn't been invoiced yet it obviously isn't included
in qryOrderInvoices.
And then when qryOrderData tries to look for InvoiceValue on those orders it
doesn't find anything of course, and shows #Error.
I have tried using Nz in various ways but cannot get rid of the #Error. I
want it to show 0 in such cases.
My field is this: InvoiceValue: Expr1 (with the source being
qryOrderInvoices)
How should I modify it, please?
Many thanks
CW