Having problems performing a search that just bring back the fields that contain words starting with A.
The field I am searching has Latin names of plants entered. I would like to be able to search just for the A's, but when I do a search for A, it is obviously searching for A in the whole word, rather than just the first letter. Also latin plant names are not always just one word, so I would like it to bring back just the first words with A.
I can sort A-Z fine, but then would like to omit B-Z from viewing.
I then would like to be able to serach for B's in the same way, omitting A & C-Z from viewing.
Anyones help would be much appreciated as I just cannot figure this one out.