Access: Filtering for records without attachments


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

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 206x300 - Access: Filtering for records without attachments

subs profile e1563205311409 - Access: Filtering for records without attachments
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address