This page on Microsoft Access VBA Codes, will in the future consist of lots of tips, questions/answers about VBA Codes and the use of them in Microsoft Access.
If you wish to know the basics on how to create code, then I suggest you purchase my VBA Tutorial. This does not only include how to create a VBA code in Microsoft Access, but will step you through the entire process of building your first code in MS Access to becoming proficient in MS Access VBA.
If you have two many nested IIFs, i.e. more than 7 or if it is just getting too messy, then a bit of code maybe necessary, to keep everything succinct, this tip will step you through how to achieve this in a query.