Query Criteria Question

[cranebill]

I want to run a query via an SQL statement in VBA. The problem lies in this. Here is the entries into the field i want to sort:

2pd
2ps
3pd
3ps
4pd
4ps

Now i want to query this based on the last character... the s and the d to be exact. How would i go about this?

Bill

 

[JohnBlaze]

You could try something like;

SELECT Right([FieldName],1) AS Name
FROM Table
ORDER BY Right([FieldName],1);