[AccessD] Query Criteria

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



More information about the AccessD mailing list