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

Chapter 6. Exploring Reports > Working with the Record Source Property

Working with the Record Source Property

You could also set the record source to an SQL query through this property. This gives you the ability to use variables to change table names. This makes the query a dynamic record source for the report.

There is another benefit from using a dynamic record source, and this applies to either a form or a report. If you are working with huge databases, involving hundreds of thousands of records, you can avoid the slower performance associated with opening a form or report tied to a single huge table. Break the table into smaller tables and access the tables dynamically. That way the user accesses one group of records at a time.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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