SELECT *
FROM Messages
WHERE ((Messages.MessageDate>Date()-7))
ORDER BY Messages.MessageDate DESC;

does the above sql seem ok to you all to filter a recordset by records added in the last week? or is there a better way?

thanks

If it ain't broke, don't fix it. <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

my sentiments exactly

thanks owen

dave<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>