in reply to Re: Logic problem on loops
in thread Logic problem on loops

OOOPS! I'm sorry -- I missed how you were working the month number into the query. But "dws" is right about the structure of the table; I was assuming that "month" information would naturally be in a column of its own.

In any case, I'd still recommend trying the approach in my ealier reply -- a single block that does the same thing for every month, with a little sub-block that does the special thing at the end of each trimester.

BTW, is there any chance that data from multiple years are getting mixed into your tables, or are you certain that the table starts out empty every January?