Thanks Leonid.
Unfortunately, I don't have any SQL programming training.
I took what you had and tried to run it and had errors.
I will be under taking some training, however, in the meantime I want to be able to run a script that would provide the info needed.
So I have found 2 seperate scripts but need to have the results produced in one report.
I would apprecaite any help you can offer.
Thanks