Howdy, Stranger!

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

Categories

QueryOfQuery ColdFusion/MsAccess - Just the record first letter

contiwcontiw Member Posts: 1
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
ContiW
Sign In or Register to comment.