Access: Filtering for records without attachments

Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Delivered once a week. free.

Q:  Don Ruppel writes:  “I am using Access 2010 to track my collection and have photos attached.  I want to filter and list any records that do not have an attachment (photo) so I know which items that need to take photos of.

Every time I try to filter the table or create a filter in a query, the “filter” controls go grey and are unselectable.

Is there any way I can isolate the records without attachments ?”

A:  The Filter selections are disabled in Datasheet view, but if you switch to Design view, you can enter a criterion of Is Null for the Attachment field, to filter for just the records with nothing stored in the Attachments field.

AW 1701-I

Want More?

Office Watch has the latest news and tips about Microsoft Office. Independent since 1996. Delivered once a week.