QueryOfQuery ColdFusion/MsAccess - Just the record first letter

The column "title" exists in a normal query.
Need to select the first letter of the titles to build a list for a prev-next alphabetical search.

I am not able to make this QoQ work.
I have tried many variations both in the SELECT statement and in the GROUP BY

SELECT left(getEntries.Title,1) as FirstLetter
FROM getEntries
GROUP BY left(getEntries.Title,1)

Any help cordially appreciated. Thank You
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!