Problem: I have a lookup field that holds numbers (options are 0 or 1). In a query, I would like to use the SUM function to add the values. For example, if I have entered two 1's and three 0's, I would like to get back the value 2. However, when I have two 1's and three 0's, I get back the value "7". The query works find on other fields that are not look-up fields. Any help is greatly appreciated.