Some additional information for you: this is really starting to bug me <g>, so I decided to try to repro your conditions.

1) Here is my sproc.  It is simpler than...

OK, look, KC, I am *far* from an expert on the subject of cursors, but there are two things I would consider here that might be different when you run...

If you're using an integer that's a DateDiff, then the VB expression I gave you should work.  No? Am I misunderstanding the question?

>L<

Yes, I totally do believe you it's the stored procedure. Sorry for getting off track with the date-conversion possibilities. 

As the last poster said, if you want somebody to figure...

Yeah, I know the suggestion in #1 will work, and #2 is basically an optimized version of #1, so it's a little more work than #1 but I would still...

>>I cannot remove the ".CommandType = adCmdCtoredProc

The reason you get the error if you remove that line is that you are not doing what I am asking you to do...

>>Lisa, is it what you want me to try? If so, it still bombed with "Operation is not alloed when the object is closed" @ the "If Not rst.BOF() Then".

No,...

Yep, there are probably 100 issues with parameter types.  That's one of the reasons why using conn.Execute rather than cmd.Execute is a good idea when you find you're having problems...

Jeff, I did read your code.  I know that you are handling the order by adding the year. I think you missed my point; you shouldn't need to compensate, because you have...

Thank you for explaining your reasoning, Jeff.  I respectfully disagree.

1. The order will almost always be determined externally to this expression anyway, since unless you can guarantee < 12 months...

Bleh.  I have been thinking about this for a couple of hours now.  And I probably shouldn't have done <g>.  (I keep waiting for somebody whose field this is to...

OK, KC, what about the other question I asked you in that message?  Are you sure you executed the command against the right object?  I can't understand how you could...

>>It complained the stored procedure expecting a @Start parameter.

That's funny, I do it this way and it works fine. Are you sure you used the connection.Execute() method? 

Remember, we're not...

Did you try what I suggested, about removing the command object from the picture, while still executing your stored procedure?

Note: this is different from confirming that the parameters return the...

Wouldn't this be handled more by the "Concurrent user" thing?

IOW, what is the max number of users who are on-line at any given time?

>L<