Search code examples
ms-accesssql-like

Like operator Range query

I am trying to design a simple query in which I want to select records from a table where the first letter of surnames lies within a single letter range.

The range is entered in the query as an expression like A-B which I call SurnameRange in the query table. Under the Surname criteria I have entered 'Like "SurnameRange*"

If I enter SurnameRange as A-B, or B-B or A-A, it produces 2 (out of 15) records beginning with A.What am I doing wrong?

Thanks for all previous answers. I have solved my problem with the BETWEEN operator Nickoby

Solution

  • I am using an Access 2007 database under Windows 10.

    Thanks for all suggestions but I solved the problem by isolating the first character of the name in a query column and, from a sub-form on the initiating form, using two range letters entered there. Then in the query I used the BETWEEN operator to establish the records I wanted. I would like to regard this topic as now closed.