G
Guest
Hi,
I'm trying to use the Dsum field in a form. I am using the =DSum("((([Trade
Date NAV]-([Corr Date NAV]+[Dist Rate]))*[Shares]))","W0005 Table","[BIN]=" &
[BIN]). My problem is that BIN is a text field. I need to change it to a
numeric. The BIN is on the form. Do I need to insert val([BIN]) in the Dsum
expression or the BIN text box or the SQL statement? Does anyone have any
ideas?
thanks
I'm trying to use the Dsum field in a form. I am using the =DSum("((([Trade
Date NAV]-([Corr Date NAV]+[Dist Rate]))*[Shares]))","W0005 Table","[BIN]=" &
[BIN]). My problem is that BIN is a text field. I need to change it to a
numeric. The BIN is on the form. Do I need to insert val([BIN]) in the Dsum
expression or the BIN text box or the SQL statement? Does anyone have any
ideas?
thanks