Distinct entries of filtered column?

[slide]

I have a text column that has some Letter in it, the format is #A-##A where A = Alpha, the last Alpha is also not required. What I want to do is get a list of all the first A's, so like i have 11P-23A, 22G-45B, 33K-67C and I want to get A,G,K is this possible?

 

[Villarreal68]

Within the Query on the field that you want to filter under Criteria enter somthing like: Like "*A" or "*K"

The "*" (Asterisk) is like a wildcard that will ignore anything else and look for any record that will have the A or K in it.

Give it a try.

 

[slide]

Villarreal68: I don't know what the A or K is, thats what I want to get a list of.

 

[Villarreal68]

Quick question: do you know what the ## is? can you maybe do: Like ##* to get what you need? Just wondering...