Every field is a particular data type. For purpose of constructing the DCount expression as shown in earlier post, the field is text, number, or date/time type. The type determines what delimiters must be used for the parameters. Note the ' and # characters in the expression. Text fields require ' delimiters for criteria and date fields require # delimiters, number type doesn't require delimiters.