Dsum is killing me

[Barry A&P]

am trying to use the following in a query that is the source for a datasheet
form


UnitsAvailable:
DSum("nz([UnitsReceived])-nz(unitssold)","T_InventoryTransactions","[partnumberID] = " & [id])

I keep getting errors. most tries prompt me for an [ID] value.. [ID] is
the name of the textbox on the datasheet form that i would like to add the
DSum to so i can have the UnitsAvailable Column.

I dont know if NZ needs to be there but some of the units sold are Nulls..

Please help i feel like i have tried a million combinations of where and
""""'s

Thanks
Barry

 

[Barry A&P]

Answered my own question...

=DSum("UnitsReceived","T_InventoryTransactions","PartNumberID = [ID]")

Never give up right