using wildcards

gtlifter

New member
Local time
Today, 08:33
Joined
Jun 13, 2011
Messages
6
Hi,
I'm trying to use a form to use as a filter tool. I've got a feild in a table with numbers in it that id like to filter by the first digit as defined in the form. I tried this:
Like ' Forms![Master List Review Report Filter]![Text31]*'

but it returns a blank result?
 
Try

Like Forms![Master List Review Report Filter]![Text31] & "*"
 

Users who are viewing this thread

Back
Top Bottom