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

Today’s coping tip is to find a new way to use one of your...

And no, the answer is not because you want to be a Microsoft MVP....

Today’s coping tip is to avoid saying “I should” and make time to do...

Hi. In source SQL Instance target linked server has been created and connection tested...

Hello, so I have a part number, and I want to display it in...

I have this column in sql server that has value of "dog,cat,mouse" so I...