Validating birthdate to be greater than 18 years
A criterion that you specify for a Hyperlink field is, by default, applied to the display text portion of the field value.
To specify criteria for the destination Uniform Resource Locator (URL) portion of the value, use the Hyperlink Part expression.
To do that, you must first familiarize yourself with the full list of functions, operators, special characters, and the syntax for expressions referring to fields and literals.
Here, you will see where and how you add the criteria.
The following examples are for the Unit Price field in a query that is based on a table that stores products information.
The criterion is specified in the Criteria row of the field in the query design grid.
The criterion is specified in the Criteria row of the field in the design grid.If the field is not already in the design grid, you add it by either dragging it from the query design window to the field grid, or by double-clicking the field (Double-clicking the field automatically adds it to the next empty column in the field grid.).Finally, you type the criteria in the Criteria row Criteria that you specify for different fields in the Criteria row are combined by using the AND operator.If you’re not sure how to make this happen, see Introduction to queries.A query criterion is an expression that Access compares to query field values to determine whether to include the record that contains each value.