newbie-ish: iif in query

[Gates Is Antichrist]

Apparently I can not define a field as

MyField: IIf(Left$([NAME],3)=”ABC”,"",[NAME])

The query designer forces square brackets, a la [”ABC”]
and then interprets it as an unknown field (the popup that essentially asks " What is ["ABC"] ?").

IIf and Left appear to be supported in this context so now I'm stuck. Help?

A2000 on Win2000. TIA.

 

[Cortici]

Aya,

This worked for me:
myfield: IIf(Left$([name],3)="ABC","",[name])

I'm not sure why you're having trouble, suspect it's something else in the query...

AH! It's your silly quotes around ABC. Use normal quotes and you'll be okay.

HTH,

 

[Gates Is Antichrist]

(groan alert) Evidently I don't understand the distinction between silly and normal

 

[Cortici]

Silly quotes as in ””

Normal quotes as is ""

You could just cut and paste my formula into your query too.

HTH,

 

[Gates Is Antichrist]

Note: when that dreaded irritating popup (i.e. input box) happens, I can just type ABC (just the letters) and hit enter, and I'm rock and roll. Ergo, I am able to function, but have to respond to that input box.

I still don't get what funny silly double quotes are

 

[Cortici]

You're using what are called right double quotes. ””
See how they're slanted

Use straight up and down quotes instead. Hit shift and then the button one to the left of enter.

Again, try copying my formula to your query.

HTH,
-Cort

 

[Gates Is Antichrist]

:idea:

I built the query in Microsoft Word. It has non generic open and close quotes. DOHHHHH

Way to go. Muchos Gs. The streets are again safe now.

Now all I have to do is understand what "normal" is. Just a personal problem :D

Sorry to run you around so much. We had a little timing problem