<Select * From TableName Where Month(CreationDate)=1;
---------
Thanks Igor, that just saved me a whole mess of programming!!! I am provided the month, year doesn't matter, since this is an archive function and I am pulling things out a month at a time and moving them to another file. I guess I really need to learn the SQL statement functions.
BTW: If you want to determine how many days are in the month, I found the following function on VB2TheMax:
'**********Determine the last day of the month Private Function mintLastDayOfMonth(ByVal intMonth As Integer, _ ByVal intYear As Integer) As Integer
