Using Expression Builder in Microsoft Access

Finally, we need to finish our expression with a bit of SQL. We wanted to count only those items with an Apple attribute value of "red". Make sure your cursor is positioned at the right side of the expression and click the Like button. Then alter the expression to read "Select ([Apple]) Like 'red'" as shown in the figure above.

That's all there is to it. Click OK and your expression will be inserted into the appropriate location in your database.