Syntax Problem

In query designer for an expression, what is wrong with this syntax?

TotQtyInsAndOuts: Nz(DSum("[QTY_ORDERED]","tblInventory", [TRNX_TYPE] in ('I','O')"),0)

Who is Participating?
Dale FyeConnect With a Mentor Commented:
You are missing a double quote in the Criteria string

TotQtyInsAndOuts: Nz(DSum("[QTY_ORDERED]","tblInventory", "[TRNX_TYPE] in ('I','O')"),0)
Dale FyeCommented:
Although if you are doing this for many records, the DSUM() could make this a long running query.  You might be better off with some form of aggregate query based grouped on a specific field (either as a stand-alone or sub query) and then joining that query to this one.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.