Query Criteria syntax...

[Trevor]

I am trying to run a query based on the input of a text
box. The text box produces a value like "x10502".
However, in the table that I am querying, the value looks
like "c:\x10502.txt". How do I get the query criteria to
add the "c:\" and the ".txt" on to the beginning and end
to run the query correctly?

Any help is much appreciated.

Trevor

 

[Cheryl]

Have you tried adding those to your parameter that picks
up the text box? or maybe in another column, building an
expression that takes the text box data and adds to other
info, i.e, ="c:\" & [textbox] & ".txt"
Cheryl

 

[Van T. Dinh]

Try a criterion like:

...
WHERE YourTextField = "C:\" & Trim([Please enter name:]) & ".txt"