Thanks Jeff I changed the column to a decimal in the table but I am still having the same problem. Should I format the Profit column that gets created in the query? Does it have a default data type if you don't specify one?  The Profit column isn't in any of the views I reference it is created only in this paticular query sort of a virtual column I guess.  Thanks again!