How do I design a query in ACCESS that returns me the left 15 characters in a field?

1 ⤊

How do I design a query in ACCESS that returns me the left 15 characters in a field?

2006-08-22 06:07:14 · 3 answers · asked by sjbchapman 2 in Computers & Internet ➔ Software

3 answers

Left([FieldName],15)

2006-08-22 12:50:47 · answer #1 · answered by Anonymous · 0⤊ 0⤋

left(myfield, 15)?

You may use the access query tool "Access Query Analyzer" at http://www.download5000.com/page25775.aspx , its'screenshot is http://www.download5000.com/screenshot25775.aspx , it allows you to visually build complete SQL scripts.

2006-08-26 03:03:00 · answer #2 · answered by weida 2 · 0⤊ 0⤋

It's been awhile, but try this:

SELECT LEFT(column, 15) FROM entity

i.e.

SELECT LEFT(authors, 15) FROM books

Hope that points you in the right direction.

edited for my own stupidity lol

2006-08-22 06:30:33 · answer #3 · answered by Anonymous · 1⤊ 0⤋