like expression

[DaveLL]

hi
i'd like to know if we can put a column name in a LIKE expression in a query
example:

LIKE "*[softwareNAme]*"
whrere softwareName is a column name in a table
I tried this and it does not give me hte results that i wants

thanks

 

[LarryDeLaruelle]

DrStein:

I'm guessing you're doing this in a query?

If so, the value within the brackets would be the prompt displayed to your user such as "Enter a Software Title".

The syntax for the statement would be:

Like "*" & [Enter a Software Title] & "*"

You would put this in the criteria cell for the field (I'm guessing) called 'SoftwareName' in the query.

Try that and let me know how it works.

Good luck.
Larry De Laruelle
larry1de@yahoo.com

 

[RickSpr]

Larry's expression uses a prompt, but you could use it for another field of the table or query as well:
Like "*" & [fieldname] & "*" Rick Sprague

 

[DaveLL]

HI
Thanks RickSpr, that's exactly what I want... it works perfectly!!!
bye

 

[skfoster]

Be sure that like "*" will not retrive null data.