Using Like Parameter in QBE

[Darrell Wootton]

Hi,

Is there a way when using LIKE to specify a field from the same query?

ie:

Like "*Wells*" returns records including the terms Wells.

I have tried using a fieldname:

LIKE "[FieldName]"
LIKE "*[FieldName]*"

But I can't get it to work.

Thanks

Darrell....

 

[Štef1]

Hello Darrel Wootton!
Look at "DemoLike2A97.mdb"

 

[Štef1]

I forgot, you can write in criteria

Like "*" & [Forms]![Form1]![Text0] & "*"