Good post, I needed some mode and median calculations in a short time frame, and your SQL was invaluable. Thanks.