Get the exact "Like" value Issue On my Query

[wcrimi]

I have a table of information that contains the distance of a race. I have a simple query that only brings up the relevant information for the exact distance I want or for all distances if I leave it black.

The is the statement I am using.

Like "*" & [Enter the Distance:] & "*"

If I leave it blank it brings up every distance just like I want.

If I enter 6F (which means 6 furlongs), 5F (5 furlongs), 1M (1 mile), 1 1/16M, 1 1/8M etc.. it works fine.

Here's the problem.



One of the table values is 7F (7 furlongs) and another is ab.7F (which means about 7F).

If I enter 7F it brings up BOTH 7F and ab.7F. I just want 7F (this the the problem)

If I enter ab.7F it brings up just ab.7F. That's correct.

Is there any way to code that statement so that if I enter 7F I only get the 7F and not both 7F and ab.7F?

Thanks

[orange]

Have you tried = "7F"?
you could try

Like "7F*" (total guess)

[wcrimi]

That was my first guess also. It didn't return anything.

[June7]

If LIKE "7F*" doesn't work then there must be some text in front of the 7 in the data.

[wcrimi]

If LIKE "7F*" doesn't work then there must be some text in front of the 7 in the data.

This worked if I hard coded it straight into the query, but there are many distances. My goal here is to be prompted to enter the distance I want and get just that one. I don't want to have to keep changing the query.

[June7]

I NEVER use dynamic parameterized queries. Cannot validate user input. Recommend binding form or report to query and using a form to input parameter to an UNBOUND textbox or combobox. Review http://www.allenbrowne.com/ser-62.html