Thanks everyone!  That was a real help!

Tony

Excellent point and that is what I did.  I add some more zeros after "us" as part of the formula.  I now have "us" plus up to 900,000 batches.

Thanks for pointing me in the...

Thanks Lowell for your help.  My batch numbers aren't arbitrary, but rather sequential.

Ninja - you were right on the money.

Thanks both of you!

Scott & PW,

Thanks for the replies.  That is what I was looking for.  It seems to me that where plausible, you use T-SQL.  I can think of times where ActiveX...

Thank you!!

That points me in the right direction and gets me started.  I appreciate that!

Tony

Thank you!!

That points me in the right direction and gets me started.  I appreciate that!

Tony

John,

That worked beautifully!!

Thanks.

Tony

Chris,

Yes it does!!!!!!!!

Thanks so much.  Now I just need to go through query to understand it and see how you came up with it. 

Thanks again.

David,

Thanks for your help.  I was taken off that project for awhile.  Now I am back on the project.  Life of a consultant.

I tried your solution and it works great...

I appreciate the fast response.

However, this does not answer the question.  These are methods I had already considered. 

The problem is that you will get one record per patient for...