您要查找的是不是：
- Fosters criteria福斯特準則
- 如果省略criteria,則DLookup函數針對整個(gè)域計算expr。If criteria is omitted, the DLookup function evaluates expr against the entire domain.
- 以下示例從記錄的“公司名稱(chēng)”字段中返回符合criteria的名稱(chēng)信息。The following example returns name information from the CompanyName field of the record satisfying criteria.
- 例如,criteria通常等效于SQL表達式中的WHERE子句,只是不包含WHERE一詞。For example, criteria is often equivalent to the WHERE clause in an SQL expression, without the word WHERE.
- 盡管criteria為可選參數,但如果不提供criteria值,DLookup函數將返回域中的隨機值。Although criteria is an optional argument, if you don't supply a value for criteria, the DLookup function returns a random value in the domain.
- 如果沒(méi)有符合criteria的記錄,或如果domain中不包含任何記錄,DLookup函數將返回Null。If no record satisfies criteria or if domain contains no records, the DLookup function returns a Null.
- Criteria為確定哪些單元格將被計算在內的條件,其形式可以為數字、表達式、單元格引用或文本。Criteria is the criteria in the form of a number, expression, cell reference, or text that defines which cells will be counted.
