SteveL13
asked on
Revise DSum syntax
I have the following DSum syntax for the control source of a field on a form. But I need to change it, Here is the current code:
=DSum("[QTY_ORDERED]","tbl Inventory" ,"[PART_NO ] = '" & [Forms]![frmParts]![txtPAR T_NO] & "'")
But I need to add two qualifiers to it.
Where TRNX_TYPE = "I" or "O"
How can I change this control source?
I tried:
=DSum("[QTY_ORDERED]","tbl Inventory" ,"[PART_NO ] = '" & [Forms]![frmParts]![txtPAR T_NO] & "'" WHERE [TRNX_TYPE] = "I" or "O")
but it isn't right.
=DSum("[QTY_ORDERED]","tbl
But I need to add two qualifiers to it.
Where TRNX_TYPE = "I" or "O"
How can I change this control source?
I tried:
=DSum("[QTY_ORDERED]","tbl
but it isn't right.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER