If you're having trouble figuring out a complex SQL statement for use in code, you may be able to simplify the process by first setting it up the query you want in the query design grid.
Once you've got it configured correctly, choose View >SQL view to reveal the underlying SQL statement, which you can copy and paste into your code.
You may have to make minor modifications, but this technique often eliminates much of the hassle of manually constructing SQL statements.
You can also tweak the underlying SQL code to adjust your Query. This code can also be copied and reused in other Queries after a little customizing.
See all Topics