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,990 reads

Today’s coping tip is to take a small step towards and important goal. One...

Hello Dear Reader! It's been a while since I had time to sit down...

I was writing some dynamic SQL that generates some SQL statements to load my...

Comments posted to this topic are about the item The Data Fabric – Future...

Comments posted to this topic are about the item The Rise of Vector Databases

Comments posted to this topic are about the item Backup Permissions