Need Query to locate specific text within a database

[NeilT23]

Trying to build a query that will Identify the last two characters within a text field. I need to search that field for any listing that ends with an _L or _F. I have tried the RIGHT Formula (Right("_L",2), but it is not working. I may be missing a wild card or may not have the query stated properly.

[lfpm062010]

In the criteria, you only need "*_L" or "*_F". The formula "Right" is not needed.
If it is not working, please post your SQL.

[NeilT23]

The reason I was trying to use the right formula is to avoid other locations where the _L or _F may be present in the text field. In other words I can have TN_LVL_HILLS_S. In this example I would pick up this item because the field contains an _L so the '*_L* will not work. The _L I am looking for is at the end of each text string but for some reason the RIGHT formula is not picking that portion of the text string..

[orange]

This will test the rightmost 2 characters in field yourFieldName to be "_L"
Right(yourFieldName,2) ="_L"

But where exactly are you using this? In a query expression? vba code?

When you need to see an example of an Access function and its proper syntax, go to
www.techonthenet.com

Try http://www.techonthenet.com/access/f...ring/right.php

[NeilT23]

Thank you!!! Thank You!!! That did it... I forgot to add the FieldName to the formula... Thank you again!!!

[lfpm062010]

For your future reference:

The wildcard "*" have to work with "LIKE".

The wildcard "*_F" will match anything that end with "_F".
The wildcard "*_L" will match anything that end with "_L".

The wildcard "*_F*" will match anything that have "_F" within the text string.
The wildcard "*_L*" will match anything that have "_L" within the text string.