<div>
Today to one week ago would be Descending (Desc)<br />
<br />
Access has an excellent Help file, if you look up these terms you should be able to put together the necessary query:<br />
<br />
DatePart, DateAdd, DateDiff<br />
<br />
<br />
SELECT CustomerHistory.DateOfSale<wbr /><br />
FROM CustomerHistory<br />
WHERE (((CustomerHistory.DateOfS<wbr />ale) Between Now() And DateAdd(&quot;m&quot;,-1,Now())))<br />
ORDER BY CustomerHistory.DateOfSale<wbr /> DESC;
</div>


Today to one week ago would be Descending (Desc)

Access has an excellent Help file, if you look up these terms you should be able to put together the necessary query:

DatePart, DateAdd, DateDiff


SELECT CustomerHistory.DateOfSale
FROM CustomerHistory
WHERE (((CustomerHistory.DateOfSale) Between Now() And DateAdd("m",-1,Now())))
ORDER BY CustomerHistory.DateOfSale DESC;

<div>
I'd like to have something like:<br />
<br />
ORDER BY DATE DESC AND TIME ASC<br />
<br />
01/06/04 10:00AM<br />
01/06/04 11:00AM<br />
01/06/04 12:00PM<br />
01/06/04 1:00PM<br />
01/06/04 2:00PM<br />
<br />
01/05/04 10:00AM<br />
01/05/04 11:00AM<br />
01/05/04 12:00PM<br />
01/05/04 1:00PM<br />
<br />
But the problem is that the date &amp;&nbsp;time are on the same field.<br />
<br />
Thanks a lot
</div>


I'd like to have something like:

ORDER BY DATE DESC AND TIME ASC

01/06/04 10:00AM
01/06/04 11:00AM
01/06/04 12:00PM
01/06/04 1:00PM
01/06/04 2:00PM

01/05/04 10:00AM
01/05/04 11:00AM
01/05/04 12:00PM
01/05/04 1:00PM

But the problem is that the date & time are on the same field.

Thanks a lot

<div>
Lowfatspread has posted a working solution to your problem<br />
Did you try it ??
</div>


Lowfatspread has posted a working solution to your problem
Did you try it ??

<div>
<div class="content wysiwyg-content">
I have a Date &amp;&nbsp;Time field in access, i'd like a SQL string to sort the records by Date (i.e.: from today to 1 week ago) and then by time , but from 10am to 7pm (i believe it's ascending?).<br />
<br />
Thanks
</div>
</div>


I have a Date & Time field in access, i'd like a SQL string to sort the records by Date (i.e.: from today to 1 week ago) and then by time , but from 10am to 7pm (i believe it's ascending?).

Thanks

SQL String to sort Date &amp; Time on the same field as Date Desc. and Time Asc.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

SQL String to sort Date &amp; Time on the same field as Date Desc. and Time Asc.

SQL String to sort Date & Time on the same field as Date Desc. and Time Asc.