Converting Access Queries with iff() and DLookup() to SQL Server
This article gives a description of the iff() and DLookup() functions in Access 2007, and a method to converting them to SQL.
SQL Server monitoring made easy "Keeping an eye on our many SQL Server instances is much easier with SQL Response." Mike Lile.Download a free trial of SQL Response now.