View Single Post
Old 04-11-2011, 12:45 AM   #3 (permalink)
mjwalsh
The Wanderer
 
Join Date: Dec 2008
Location: Houston, TX
Posts: 14
Thanks: 1
mjwalsh is on a distinguished road
Default

I don't understand the need for this, can you explain it more? The way you explained it, you could just select all of them from the table and display them by order of the date field, IE:

SELECT * FROM tblTable01 ORDER BY fldName2 ASC

Assuming the dates are in proper formate and the field is set to date or datetime it will work fine and display in the dates order.
Send a message via AIM to mjwalsh Send a message via MSN to mjwalsh
mjwalsh is offline  
Reply With Quote