Yes Garrett...that works but it will result in only a single count. What I'm trying to do is have a number of conditional counts assigned to a number of variable names within one SQL statement. Possible...?