I am in using the new .adp Access format on top of SQL 2000. In the .mdb format I could write if statments in my queries like this in the field name: TotalAmt: If(Total>0, Total, 0)

How do I do this in the column of my query now that I am using SQL 2000 as a back end?