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

9,476 reads

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

Hello, data friends! Let me spread a few words about the new MVP led...

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

Hi, I have a query like "Select tablenumber from a table" Tablenumber 1 2...

Hi there, we have SQL Server 2014 (Build - 12.0.6259.0) and my database have...

Hello Everyone, At work, I've been getting more involved with hosting and database stuff....