ASP.NET, SQL Server, WPF, C#, VB.NET

Hi, 
 
I am doing an access project with SQL backend. I am sure this must have been 
 
discussed earlier, but was not able to trace the solution: 
 
i have a field for which i want to formulate the below, except that instead 
 
of 0 for the false, it should allow me an input. 
 
Currently if the status is 2, it correctly computes the value, but when the 
 
status is any other number, it returns 0 because of the below statement.  Can 
 
someone please help me formulate this so that when false it should either 
 
prompt me for a value or allow me to type in a value into the field?? 
 
case [STATUS] when 2 then (convert(money,round(([invqty] * [invprice]),2))) 
 
else 0 end) 
 
thank you for any help. 
 
Gmenon 
 
-- 
 
Message posted via AccessMonster.com 
 
http://www.accessmonster.com/Uwe/Forums.aspx/access-adp-sqlserver/200608/1

gvA> Currently if the status is 2, it correctly computes the value, but 
 
gvA> when the status is any other number, it returns 0 because of the below 
 
gvA> statement.  Can someone please help me formulate this so that when 
 
gvA> false it should either prompt me for a value or allow me to type in a 
 
gvA> value into the field?? 
 
The code running on the server can't do that. You need to do that in the 
 
code of your frontend part. 
 
Vadim Rapp

I am just a novice and would appreciate if you can elaborate this for me. 
 
Vadim Rapp wrote: 
 
-- 
 
Message posted via http://www.accessmonster.com