title: How to query number of attachments from Attachment field in Microsoft Access?
body: <p>One of my users has a Microsoft Access database and in the table he has an attachment field. In one of his queries, he wants to return the number of attachments that the field contains. I have tried to get this to work to no avail. I've tried creating a VBA module and passing into it the field but it errors on me. I've tried creating the parameter as a DAO.Recordset, DAO.Field, Attachment, etc.</p>
  
  <p>I've also tried querying the field like this [MyField].AttachmentCount.</p>