SteveL13
asked on
Syntax Problem
In query designer for an expression, what is wrong with this syntax?
TotQtyInsAndOuts: Nz(DSum("[QTY_ORDERED]","t blInventor y", [TRNX_TYPE] in ('I','O')"),0)
--Steve
TotQtyInsAndOuts: Nz(DSum("[QTY_ORDERED]","t
--Steve
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.