ACCESS 97 - IF FUNCTION

  TABBYCAT 18:30 08 Dec 2003
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 2003

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 2003

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 2003

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.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?