 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / April 2005IIf Function
I keep getting error messages with the syntax or commas in my IIf function. I've listed it as IIf(And([Sq Ft]=>70,[Sq Ft]<=280),1,[Sq Ft]/140). What am I missing or what have I stated incorrectly? The syntax is incorrect on your And IIf([Sq Ft]=>70 And [Sq Ft]<=280 ,1,[Sq Ft]/140) > I keep getting error messages with the syntax or commas in my IIf function. > I've listed it as IIf(And([Sq Ft]=>70,[Sq Ft]<=280),1,[Sq Ft]/140). What am I > missing or what have I stated incorrectly? Is this an Access question or Excel Question? If it is Access, there is no "And" (spreadsheet) function in Access. You need to use the And Boolean operator, i.e. {Boolean expr} And {Boolean expr}  SignatureHTH Van T. Dinh MVP (Access) > I keep getting error messages with the syntax or commas in my IIf function. > I've listed it as IIf(And([Sq Ft]=>70,[Sq Ft]<=280),1,[Sq Ft]/140). What am I > missing or what have I stated incorrectly? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.