Getting the first letter of a field

[George Thompson]

How can I retrieve the first letter of data in a field within access?
(using access 2k?) is this a VB thing or is there an obvious solution?

[David B]

in a Query use this - Left([yourfieldname],1)

HTH
David B
George Thompson <do**********@hotmail.com> wrote in message
news:c5*************************@posting.google.co m...

How can I retrieve the first letter of data in a field within access?
(using access 2k?) is this a VB thing or is there an obvious solution?

[Ronald W. Roberts]

George Thompson wrote:

How can I retrieve the first letter of data in a field within access?
(using access 2k?) is this a VB thing or is there an obvious solution?

FirstChar=Left(SomeField,1)

--
Ronald W. Roberts
Roberts Communication
rw*******************@robcom.com
To reply remove "_at_robcom_dot_com"

[WiseOwl]

Another way, as the search criteria, is to let the query perform a paremeter
search...

[Question]*.*

Replace 'Question' with a user prompt, such as "Which letter do you want to
search for?".

The query then searches for this letter and appends it to the wildcard *.*.

E.g. Entering L in surname field will result in all surnames beginning in L
being listed.
"George Thompson" <do**********@hotmail.com> wrote in message
news:c5*************************@posting.google.co m...

How can I retrieve the first letter of data in a field within access?
(using access 2k?) is this a VB thing or is there an obvious solution?

[Peter Russell]

George Thompson previously wrote:

How can I retrieve the first letter of data in a field within access?
(using access 2k?) is this a VB thing or is there an obvious solution?

Assuming you mean the leftmost character (whether a letter or a number)
then you can use a function
Left(myfieldname,1)

Peter Russell