Query Question (97)

Topic

New Reply

I would like to create a query to retrieve a specfic value in the 13 th position of an 18 charater text field.

I have used the like command with *, however it gives me more records then I need. Any help would be appreciated

Reply | Quote

Replies

MID([FieldName],start_num,num_chars). For your query use: Mid([YourFieldName],13,1)

Reply | Quote

I replied too quickly. You want to use this on the criteria line of your query, for the text field you mentioned: Mid([YourFieldName],13,1) =”value”. Replace “value” with the value you’re looking for.

Reply | Quote

Thank you ever so much this was exactly what I needed!

Thanks, again

Reply | Quote

If you want a parameter query, then instead of my previous reply, create a new column in your query with the field name as an expression: Mid([YourTextFieldName],13,1). Then in the criteria of this new column put this: [Enter Value].

Reply | Quote