Handling nulls found in expression

C

CW

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
 

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

Handling nulls found in expression 1
#Error when record is not found in query 3
Help or suggestion needed on tabledesign 4
Access Expression builder 1
Query to include null values 8
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
How to Handle Nulls in SQL? 7
Sort by summed field 2

Top