• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 23. Further Dynamic Techniques > Working with Complex Recordsets

Working with Complex Recordsets

SQL is a powerful language that can collect data in all sorts of ways. To help you with this, the Recordset dialog box can operate in simple or advanced mode. Simple mode is quick and easy for collecting, filtering, and sorting basic recordsets. But for table joins, grouping, using calculated fields, and other more sophisticated tasks, only advanced mode will do (see Figure 23.12). In this mode, you can write your own SQL, use the Data Tree to help create complex statements, and incorporate variables (parameters) into your SQL.

Figure 23.12. The Recordset dialog box in Advanced mode.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint