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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

myztical - 09 Mar 2006 20:42 GMT

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

Reply to this Message

Rick B - 09 Mar 2006 20:58 GMT

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.

Signature

Rick B

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

Reply to this Message

Douglas J Steele - 09 Mar 2006 21:08 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

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

Reply to this Message