I personally find it hard to write nested SQL in MS Access, as it is hard to follow the parentheses throughout the SQL in a query. For instance, when one write a formula in Excel 2007, the parentheses and other parts of the formula are highlighted in various colors so it is easy to tell where you are in the code.
My question is; is there a tool that will enable me to do something like this in Access 2007? It doesn't have to actually work with Access, as I can simply write the SQL in the tool, and paste it into Access if I need to. Thanks in advance, Jon
p.s. Is it correct terminology to call SQL "code", or is it called something else. Additionally, is it correct to call a formula in Excel code or is it simply referred to as a formula.