ACCESS 97 - IF FUNCTION

  TABBYCAT 18:30 08 Dec 03
Locked

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.

  recap 19:02 08 Dec 03

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.

  AndyJ 20:24 08 Dec 03

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

  recap 18:05 09 Dec 03

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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

Best Christmas Agency Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…