John Bartow
john at winhaven.net
Mon Mar 31 14:14:43 CST 2003
MessageYou probably need to give us more details but I tend to agree in philosophy with the idea that IIF should not be used unless necessary. But in practice it is sometimes necessary. I have it used it mostly when querying a pre-existing database which is poorly normalized (hmmm, that might be an oxy-moron). I use it as a guideline not a rule though, the only "rule" I tend to have is to never rule out anything. I think the biggest drawback beyond speed is that its Access specific and they can be difficult to read. I think "spreadsheet people" love it though. JB -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] Sent: Monday, March 31, 2003 1:39 PM 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 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030331/b7f0b9eb/attachment-0001.html> -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 1024 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030331/b7f0b9eb/attachment-0001.bin>