G Guest Mar 9, 2006 #1 Using Access 2003 and trying to convert an excel formulat into Access, but Access doesn't recognize "then".
Using Access 2003 and trying to convert an excel formulat into Access, but Access doesn't recognize "then".
R Rick B Mar 9, 2006 #2 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.
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 Mar 9, 2006 #3 Are you using the If statement or the IIf statement? (The latter is the equivalent of Excel's If statement)
Are you using the If statement or the IIf statement? (The latter is the equivalent of Excel's If statement)
