[AccessD] Query Criteria

Admin Sparky dba.email at gmail.com
Mon Feb 21 10:20:30 CST 2005


Gustav,

Thank you.  This allows me to run the query the requisite number of
times.  How then would I feed the current month/year of the loop into
that query as criteria?


Mark


On Mon, 21 Feb 2005 16:00:53 +0100, Gustav Brock <Gustav at cactus.dk> wrote:
> Hi Mark
> 
> I would use
> 
> intMonths = DateDiff("m", dteStart, dteEnd)
> For intMonth = 0 To intMonths
>  ' Run query.
> Next
> 
> /gustav
> 
> >>> dba.email at gmail.com 21-02-2005 15:46:51 >>>
> 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
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



More information about the AccessD mailing list