Is it possible to add the Total Row when you create a Select Query o the fly using the CreateQueryDef and sql? Also, in the QBE grid, in the Properties of a column you can set the number format. How would I do that in my sql? For example set #,##0.00? When I set those properties, they don't appear when I view the SQL so I'm wondering how and where they are saved.