<div>
Try..<br />
<br />
SELECT * FROM <br />
tblCourtTime<br />
ORDER BY tblCourtTime <b>/* ASC OR DESC /</b>
</div>


Try..

SELECT * FROM
tblCourtTime
ORDER BY tblCourtTime /* ASC OR DESC /

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I have a question about sorting hours by AM and PM<br />
currently I have a tblCourtTime and have a auto# as primary key, &nbsp;we entered time, for example: we have 8:30 AM, 9:05 AM, 1:20 PM etc. &nbsp;what &nbsp;I want to do is create a query but will list all AM then PM, some time I have to enter 8:45 AM, so 8:45 AM is going to under 8: 30 AM. &nbsp;I know I can not sort by Auto#. &nbsp;any idea? &nbsp;Thanks<br />
<br />
here is my query:<br />
SELECT tblCourtTime.CourtTime<br />
FROM tblCourtTime;
</div>
</div>


Hi Experts,
I have a question about sorting hours by AM and PM
currently I have a tblCourtTime and have a auto# as primary key,  we entered time, for example: we have 8:30 AM, 9:05 AM, 1:20 PM etc.  what  I want to do is create a query but will list all AM then PM, some time I have to enter 8:45 AM, so 8:45 AM is going to under 8: 30 AM.  I know I can not sort by Auto#.  any idea?  Thanks

here is my query:
SELECT tblCourtTime.CourtTime
FROM tblCourtTime;

sort Time by AM and PM in 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.