Admin Sparky
dba.email at gmail.com
Mon Feb 21 08:46:51 CST 2005
Group, Monday morning has arrived:( I have a form with 2 calendar controls that can provide a date range. I would like to use this date range as criteria for a query. However, I am having difficulty with the following scenario. Given a multiple-month date range, I would like to run the query "n" number of times for each month in the range. The solution must be able to span multiple years if needed. Pseudo code: dteStart = 8/1/2004 dteEnd = 1/31/2005 For each month in the date range run the query Next month Any suggestions? Mark Mitsules