title: Performance comparison for SWITCH vs IIF?
body: <p>Background: migrating legendary Excel Reporting projects into MS Access for the very need of database structure.</p>
  
  <p>Limitation: Development environment is within Excel and Access. Due to large chunks of data processing and keeping of moving n-Months data, it can't afford to loop via recordsets. </p>
  
  <p>Issue: In current Excel reporting platform, there are multi number of sub tools are used separately to process data. As a result ithas the priviledge to process small chunks of data by going through each row. Conditional checks are performed using IF-ELSE. </p>
  
  <p>In proposed MS Access structure, these IF-ELSE are converted into IIF. Given theis situation, would like to know opinions on performance comparison of IIF vs SWITCH. Any better solutions are most welcome.</p>
  
  <p>PS:  after importing source, the db is auto closed to compact and repair as it "bloats". eventually db should be compatible for both ms 2003 and 2010 packages</p>