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