Query quesion

[cynthialea]

1st post, and I hope it's in the right area.



I have a basic DB setup with a position code, descr and I have anothe column that I want the result to show only the last letter of the pos code

I want to run the query, ask what pos code to search (Like "*" & [Which Pos Code to search ] & "*"), type cbnagt. It pulls up this info and in C I only want the last letter and I want to be able to see which letter is available for the next position I need to assign.

A B
xxxcbnagtxxa Cabin Agent a
xxxcbnagtxxb Cabin Agent b
xxxcbnagtxxd Cabin Agent d

Thanks in advance

[pbaldy]

If I understand correctly:

Right(FieldName, 1)

will give you the last letter.

[cynthialea]

I had been doing that but either I must have had somehting wrong. I ended up doing a subquery

TypeLetter: Right([Lastletter],1)