Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Oracle vs. Access
I've been using the SQL version of Report Smith for the last year. Now we've switched to the Oracle version. Could you explain DECODE() to me?- pbowen
- Post #3
- Forum: Strategic Reporting Systems(SRS): ReportSmith
-
Oracle vs. Access
Do you have access to the @IF or IIF function (@IF(number, Value1,Value2) - returns value 1 if number = 0 else returns value 2? i.e. @IF(tablename.fieldname,7000,0) This would return "7000" if tablename.fieldname has a value, otherwise would return "0". Or...- pbowen
- Post #2
- Forum: Strategic Reporting Systems(SRS): ReportSmith
