Fred Simmons

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2.92 (38)

2010-03-08

8,912 reads

(2021-July-30) A picture is worth a thousand words, the same way a visual database schema...

You might be asking why on earth would you want to get a database...

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Hi Guys, I have an SQL Server 2012 Express database that I would like...

Comments posted to this topic are about the item Deploying SQL Server Automatically

I well realize data compression is a subject to a few variables, such as...