Michelle,

I use SQL Wizard a lot, the advantage is, you can test and modify, don't have to save your code, until you think it is right or close to what you want, get the code from wizard, copy it to your program make some minor modifications. the disadvantage is that Wizard does not handle complex SQL SELECT such as subsequent SELECT, AS 'MyFieldName' etc.

If you are interested, click File, New, Query, New File, you will get to it, right-click displays some more functions that are useful.

David