Using an expression to add a record based on a field containing any text

[peter_lawton]

In Access 2002 I am attempting to add text to Field 2 if Field 1 contains any text at all using a query expression.



I have tried innumerable combinations of IIf, Is Not Null, Like using wildcards etc. For example IIf([Composer] is not null), "CA" (Suggested on an MS site) however I can't seem to find the right expression. I know this should be simple so please excuse my dumbness today.

Help greatly appreciated

Peter

[Robeen]

I read through your post a few times trying to figure out whether you're trying to get what you need using a query or using VBA code in a Form . . .
Can you post some more details and perhaps the entire SQL?

Your IIF statement does not appear to be posted in its entirety - and it also appears to be syntactically incorrect?
It should read something like this:

IIf([Composer] Is Not Null, "CA", "Value_If_False")

[peter_lawton]

I'm just trying to Using your expression

Composer1 Composer1_Capacity Composer2 Composer2_Capacity

Apple CA Carrot
Orange CA
Cherry CA Swede
Mango CA
Banana CA Cabbage

SELECT Composer.Composer1, Composer.Composer1_Capacity, Composer.Composer2, Composer.Composer2_Capacity
FROM Composer
WHERE (((Composer.Composer2_Capacity)=IIf([Composer2] Is Not Null,"CA","Value_If_False")));

Also tried IIf([Composer2] Like "*" ,"CA")

Same Result

but then I had a thought

SELECT Composer.Composer1, Composer.Composer1_Capacity, Composer.Composer2, IIf([Composer2] Like "*","CA") AS Composer2_Capacity
FROM Composer
GROUP BY Composer.Composer1, Composer.Composer1_Capacity, Composer.Composer2;

Solved

You got me thinking thanks

Peter