Thread: If Statement in a SQL Query?
09-18-03, 19:20 #1Registered User
- Join Date
- Sep 2003
Unanswered: If Statement in a SQL Query?
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?