Both methods work great. Thanks guys. I have never used Common Table Expressions. So that is something I will look into a little further.

Thanks again:satisfied:

All:

I'm still trying to get a handle on this. My apologies for not being more specific.

I'm including code to create the necessary tables. HTH. Again, I'm...

Jeff:

First and foremost, thank you very much for the help you have been providing me. It is helping me to both learn more and have a stronger grip on...

Not yet Jeff. Between the syntactical nightmares I'm coming across (creating the sp) and the fact that I can't come up with a good way to present it to...

Hello Again Everybody:

I'm trying to take this whole thing a step further. I would like to turn this into a stored procedure for use in my .adp front end. ...

I'm in the same boat. Currently with a broken paddle. Based on the suggested code, I tried...

Dim cmd As ADODB.Command

Set cmd = New ADODB.Command

cmd.ActiveConnection = CurrentProject.Connection

cmd.CommandType = adCmdStoredProc

cmd.CommandText...

This code worked swimmingly!! Thank you Jeff and all!!:-P

Ok All:

I'm back. Thanks to Jeff for pointing me in the right direction as far as posting goes. Thanks to everyone else for the suggestions so far.

I'm posting...

Thanks for all of the advice. I'm wondering though.. Can I use Pivot without having aggregate functions? I started to work on a select statement, but I only...

If you don't mind, could you send me a sample.  I think I'm following you, but an example would help.

Thanks!

If you have a code sample for this, that would be great. 

Using cursors was suggested as a solution and it seems to fit pretty well.  At least the code is working as I expect it to.  I will try making the...

Hello All:

Thanks for all the help so far.  I just wanted to share what I ended up with with everyone.  The first block of code is my solution.  Please let...

Thank you all for the great support so far!

Carl:  I'm attaching the files you requested.  Hopefully this clears it up a little. 

Terry:  Your code works great.  Do you think...

Sorry About that.  I realized I was in SQL2K5 when I should have been in 2K.  Can I remove this post?