Like and Macros

[Flow]

Hello, I have a bit of a problem and I will be grateful if anyone could give
me some suggestion

I want to filter out data using wildcard. Using a macro I am opening up a
query then in the filter condition I am using

[Product Table Query]![Trial Names]=Like[A*]

But it doesnt seem to work. Have tried a few variations including % and
using the Like in front of query etc.
Any suggestions will be greatly appreciated

 

[Al Camp]

In an SQL statement... (use your names)
WHERE (((tblAddresses.LastName) Like "A*"))
In the query design grid the criteria would be entered in the LastName
column as...
Like "A*"
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions