Thread: Get Counts
View Single Post
  #3 (permalink)  
Old June 9th, 2003, 10:52 PM
harpua harpua is offline
Friend of Wrox
Join Date: Jun 2003
Location: Oklahoma City, Oklahoma, USA.
Posts: 249
Thanks: 0
Thanked 0 Times in 0 Posts

Thanks for the ideas my brain feels better. I thought of the 2 recordsets but was hoping there was a more efficient way of doing it with one statement, I'll use your second suggestion, again thanks the help.