Dsum is killing me

  • Thread starter Thread starter Barry A&P
  • Start date Start date
B

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
 
Answered my own question...

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

Never give up right
 
Back
Top