Count last 4 letters of field 1

[Taff82]

Hi All,

Not sure at all if this is possible, but here goes.

I have a field which is made up of letters. The field is 8 letters long and I was wondering if it is possible in a query to count the last four letters of the field in the table and see how many of them there are.

For example: -

Field
AAAA
AAAA
AAAA
AAAB
AAAB
AAAB
AAAD
AAAD

If I were to count them it would look something like this: -

Field Count
AAAA 3
AAAB 3
AAAD 2

Not sure if that is clear enough.

Any help is greatly appreciated.

Many Thanks,
Anthony.

 

[SuicidED]

Hi
SELECT Right([letterfield],4) AS Test, Count(Table1.Letterfield) AS CountOfLetterfield
FROM Table1
GROUP BY Right([letterfield],4);

 

[Taff82]

Hi SuicedEd,

Exactly what I was after.

Thanks

Anthony