DigitalOmaha — Sun, 23 Oct 2005 19:55:32 +0000

Just add a Date column/field to any table containing data you wish to archive by month. Insert the current date into that column on creation and/or update (or add a new column for updates). Then add this to the select statement "WHERE DATE < 02/01/2005 AND DATE >= 01/01/2005" (you need to check the database date format on your system this is more as an example).

Now all you need to do is setup some way of setting the month your looking at from within the page. A dual nested combo box with year and then month would work the best.

Cheers!