Convert excel formula to access =if(O1>N1,N1-O1,0)

M

myztical

Using Access 2003 and trying to convert an excel formulat into Access, but
Access doesn't recognize "then".
 
R

Rick B

What are you trying to accomplish with this formula and where are you
putting it? What are the field names?

What results are you getting and what result do you expect?


Details please.
 
D

Douglas J Steele

Are you using the If statement or the IIf statement? (The latter is the
equivalent of Excel's If statement)
 
Top