View Single Post
  #2 (permalink)  
Old August 9th, 2005, 01:08 PM
sdilucca sdilucca is offline
Authorized User
 
Join Date: Jun 2004
Location: , , USA.
Posts: 51
Thanks: 0
Thanked 0 Times in 0 Posts
Default

ok... i'm going to take a crack at this...

I have used the expression "COUNT(distinct" in the past and it has given me problems. Maybe it's not giving you problems. Not sure.

I would use the BETWEEN function in your WHERE clause for the date filtering.

Question... what is the datatype for your inactive fields?

Julio Cesar

-"Life is a Database"