I realize that the point of this article was to compare joins to subqueries but I would have thought to use the rank function. Here is how I would...

Thanks for your response Yelena. I think this is on the right track. I don't really know VB or C so I am thinking that calling Excel from...

Nevermind, I moved the calculation to the front (i.e. 1.00*...) and that worked. Thanks!

Thanks for your response. I tried your suggestion on my example and that works but for some reason it is not working on the data I am pulling from...

That's it! Thanks so much.

I ran your script and it tells me that I am not a sysadmin.

Yes, this looks very promising. I will try it. Also I found your link to forum ettiquitte to be quite helpful too. Thanks.

Jon

That's ok, I would rather be a little overwhelmed and be learning than not doing a proper job. Thank you for your suggestions. I appreciate it.

Geesh, I realize how much I have to learn after seeing your response! The kind of reporting I was thinking of was more along the lines of after a...

Chrissy321,

This sounds just like what I have in mind. Being a newbie I have to admit I don't understand a lot of what you said (:unsure:

This is appears to...

Thanks for your suggestions. I was not clear but the reports I have in mind are just for me as a way of reviewing the results so as to...