Read: How to add Totals in Reports in Microsoft Access. 2] Filtering Records in Access There are three methods you can use to filter data. Method 1 is to click the drop-down arrow next to the field.

Susan Harkins explains how to populate an Access list control instantly by setting properties at the field (table) level to create a lookup field.