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

Creating a Query

As I've said, the end result of a query is a dynaset, which looks and acts very much like a table's datasheet. So you might expect that the process of creating a query is similar to that of creating a table, and, in fact, it is. Both processes involve three steps:

1.
For a table, you begin by creating a new table object. For a query, you create a new query object.

2.
A new table is empty, so you have to define its basic structure by adding fields. New queries are also empty and also need fields to define their structure. The difference, as you'll see, is that the query's fields come from an existing table.

3.
In a table, you then need to flesh out the structure by entering data into new records. Queries, too, need records to give them substance. In this case, though, you “enter” records into the query by defining the criteria the query uses to extract records from the underlying table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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