Query Criteria syntax...

  • Thread starter Thread starter Trevor
  • Start date Start date
T

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
 
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
 
Try a criterion like:

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