The only way that I could fathom it could be done in one query is if you used a Select Into and somehow got it to return the count instead of the data. I've searched the internet for the answer and haven't found anything yet though. I'll keep playing around with it and if I find a solution I'll post it back.