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.
iMac Pro review
25 book design and illustration tips
Idées cadeaux pour geeks et tech addicts
© Copyright 2018 IDG UK. All Rights Reserved.