I FIND THE "IF" FUNCTION IN EXCEL 97 VERY USEFUL.I WOULD FIND IT USEFUL IN ACCESS 97 ALSO. IS THERE SUCH A FUNCTION WHEN BUILDING AN EXPRESSION IN AN ACCESS 97 QUERY? I'VE TRIED SIMPLY SAY "IF [FIELD1]>20 THEN "YES", OTHERWISE "NO" BUT NO JOY.
Try the following: = IIf([OrderAmount] > 1000, "Large", "Small")Polite note, please turn off your `Caps Lock` using caps while on the Net is classed as shouting.
Can I just add to recap's answer ('cos I think he forgot to mention) that the If statement in Access is written as "IIf" not "If" - good ole recap didn't make a typing error
Yes, sorry I should have mentioned it. Thanks AndyJ for pointing it out. It's been quite a while since I used Access, I had to do some digging in my memory for that one n these ole brain cells aren't what they used to be, LOL ;-)))
This thread is now locked and can not be replied to.
Galaxy Note 8 vs iPhone X
Awful clip art from 1994 is being tweeted every hour by a bot
iPhone X vs Samsung Galaxy Note 8
Les meilleurs navigateurs internet 2017
© Copyright 2017 IDG UK. All Rights Reserved.