sorting recordset by date

And lo, I Need Help! didst speak in alt.www.webmaster:

 > SELECT *
 > FROM for_sale
 > ORDER BY ListDate Desc
 >
 > I want to limit it to last 7 days. How would the SQL be written for
 > Access?

What format is ListDate in? If it's a UNIX epoch timestamp (doubtful if
you're starting with Access), then you can just include a WHERE clause:

SELECT *
FROM for_sale
WHERE ListDate>=UNIX_TIMESTAMP()-604800
ORDER BY ListDate Desc

Otherwise, it's time to do some googling for the Date and Time functions
you have available in Access.

Grey

--
The technical axiom that nothing is impossible sinisterly implies the
pitfall corollory that nothing is ridiculous.
- <a style='text-decoration: underline;' href="http://www.greywyvern.com" target="_blank">http://www.greywyvern.com</a> - Orca Knowledgebase: Completely CSS styleable
Knowledgebase/FAQ system<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: sorting recordset by date 

"I Need Help!" <iamedia DeleteThis @hotmail.com> wrote in message
news:ctambd$2rcf$1@otis.netspace.net.au...
 > SELECT *
 > FROM for_sale
 > ORDER BY ListDate Desc
 >
 >
 >
 > I want to limit it to last 7 days. How would the SQL be written for
 > Access?
 >

SELECT *
FROM for_sale

WHERE DateDiff( "d", [ListDate], Int(Now())) ) <= 7

ORDER BY ListDate Desc


I suggest Int(Now()) as the decimal part of Now() represents hours, mins,
sec which you probably don't want<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: sorting recordset by date