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