[AccessD] IIf in query discussion

Wortz, Charles CWortz at tea.state.tx.us
Mon Mar 31 13:45:55 CST 2003


References please!  Unless we know what this "Access expert" said, it is
hard to comment on it.

Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Myke Myers
Sent: Monday 2003 Mar 31 13:39
To: accessd at databaseadvisors.com
Subject: [AccessD] IIf in query discussion

Recently I read an article by an Access expert who suggested that using
'iif' in a query is a rookie mistake.

I've made that mistake.

My question: Does using 'iif' in a query just slow done processing, or,
does it have more substantial consequences?

TIA,
Myke


More information about the AccessD mailing list