<div>
Something like:<br />
<br />
SELECT * FROM yourTable<br />
WHERE [Last Name] &gt;= Forms!yourForm.txt_StartLe<wbr />tter<br />
ORDER BY [Last Name] ASC
</div>


Something like:

SELECT * FROM yourTable
WHERE [Last Name] >= Forms!yourForm.txt_StartLetter
ORDER BY [Last Name] ASC

<div>
I just tried to run the query first without any forms, it's pull from tables. &nbsp;no quite sure if I can use &quot;Forms!yourForm&quot; &nbsp;what is the txt_startletter?
</div>


I just tried to run the query first without any forms, it's pull from tables.  no quite sure if I can use "Forms!yourForm"  what is the txt_startletter?

<div>
That SQL assumes you have a form open, and have a textbox named &quot;txt_StartLetter&quot;. &nbsp;Then you would either use the AfterUpdate event associated with that textbox, or a button, to open your query.
</div>


That SQL assumes you have a form open, and have a textbox named "txt_StartLetter".  Then you would either use the AfterUpdate event associated with that textbox, or a button, to open your query.

<div>
I'm trying to create a report, I need to have a query first and I added &gt;= &quot;L&quot; in the criteria of the query, it pull all the letter from L to Z, what about if I just want to pull from L to P?
</div>


I'm trying to create a report, I need to have a query first and I added >= "L" in the criteria of the query, it pull all the letter from L to Z, what about if I just want to pull from L to P?

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I have a query question. &nbsp;my query has a field &quot;Last Name&quot; and sort it by alphabet order from A to Z, how to I do if I just want to pull from L to Z? &nbsp;I have a field which call Last Name A: Left([LASTNAME],1) <br />
<br />
Thanks
</div>
</div>


Hi Experts,
I have a query question.  my query has a field "Last Name" and sort it by alphabet order from A to Z, how to I do if I just want to pull from L to Z?  I have a field which call Last Name A: Left([LASTNAME],1) 

Thanks

Alphabet order in access query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.