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

Nulls and Query Results

Null values in your table's fields can noticeably affect query results. A Null value is different from a zero or a zero-length string; a field contains a Null value when no value has yet been stored in the field. As discussed in Chapter 3, a zero-length string is entered in a field by typing two quotation marks.

Null values can affect the results of multitable queries, queries including aggregate functions (Totals queries), and queries with calculations. By default, when a multitable query is built, only records that have non-Null values on the “many” side of the relationship appear in the query result (discussed earlier in this chapter, in the “Pitfalls of Multitable Queries” section).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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