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.
Office Watch has the latest news and tips about Microsoft Office. Independent since 1996. Delivered once a week.