I'm trying to determine if the number is odd or even to do my median function that i posted about before. What i'm trying to do is find the record count and then divide by 2 and depending if it's odd or even either go directly to the median or if even then take the average of the 2 middle records. Thanks for the help