S
swichman
I hate the syntax requirements on these stupid things...
Can anybody tell me what is wrong with the following:
=DSum("[QuantityRevision]*[UP]","Quantity Adjustments","[SCO] = -1 And
[PCOFinal] = 0 And [Group1D] Is Null " And [ContractID]=" &
[ContractID] And [ItemNum] = '" & [ItemNum] & "'")
It is not working and it has somethng to do with " And [ContractID] = "
& [ContractID]
ContractID is a Long Integer.
Thanks for any help.
Can anybody tell me what is wrong with the following:
=DSum("[QuantityRevision]*[UP]","Quantity Adjustments","[SCO] = -1 And
[PCOFinal] = 0 And [Group1D] Is Null " And [ContractID]=" &
[ContractID] And [ItemNum] = '" & [ItemNum] & "'")
It is not working and it has somethng to do with " And [ContractID] = "
& [ContractID]
ContractID is a Long Integer.
Thanks for any help.