This page on Microsoft Access Queries, will in the future consist of lots of tips, questions/answers about Queries and the use of them in Microsoft Access.
If you wish to know the basics on how to create a query, then I suggest you download my free tutorial. This does not only include how to create a query in Microsoft Access, but will step you through the entire process of building your first database in MS Access. To learn the basics of Microsoft Access then:
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 queries.