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.