Using a wildcard if an IIF statement.

[atlee]

Hi Everyone



Could somebody please help me out with the following: How do I use a wildcard in an expression on a form? E.g. If a postcode is either CR0 4** or CR0 3** I want it to return a value of "Beddington North"? So far I have tried: =IIf([Post Code]="CR0 3AR","Beddington North") but this obviously only returns Beddington North if its an exact match. I have tried substituting the AR for * but then I get no return.

Grateful for any help.

Thanks
andrea

[pbaldy]

Try

=IIf([Post Code] Like "CR0 3*","Beddington North")

[atlee]

Thanks so much, perfect. What do I use if I want it to use CR0 3* or CR0 4*?

[pbaldy]

=IIf([Post Code] Like "CR0 3*" Or [Post Code] Like "CR0 4*","Beddington North")

[June7]

Works without the not true argument?

=IIf([Post Code] Like "CR0 3*" Or [Post Code] Like "CR0 4*", "Beddington North", Null)

[pbaldy]

Why don't you test? I did.

[June7]

Okay, why does it work (defaults to Null) with LIKE and wildcard but = generates 'wrong number of arguments'? Guess I've never used LIKE and wildcard in a textbox expression.

Correction, now I'm not getting the error even with = expression!!%? Don't know what I did different.

Suppose I've always automatically included the False argument.

Learn something new!