Attachments in Queries

[rachel_harder]

Hello all,

I am working with access 2010 and I have a database that has attachments in the table. I have set up a query to in by database but every time I have a record with 2 or more attachments on it it shows that record as two different records in my query. I am wondering if there is a way I can make the query show one record and to be able to view attachments like in the original table. Thanks for your help.

 

[CJ_London]

I don't use attachment fields but believe they work in much the same way as a multivalue field in that they are effectively a 'hidden recordset' within a table.

have a record with 2 or more attachments on it it shows that record as two different records in my query

I would expect this to be 'two or more different records'

I would expect a query where you use

myAttachmentField

would produce a single row and

myAttachmentField.Value

would produce multiple rows

I've had a quick google on attachment fields but with limited success in terms of your question

here are a few I found which may help
http://www.fmsinc.com/microsoftaccess/attachment-field/index.html
http://www.cimaware.com/resources/article_135.html
http://www.pcreview.co.uk/forums/ole-vs-attachment-field-t3951813.html

and this one - you need to go about 3/4 down the page - look for 'Using an Attachment'
http://www.functionx.com/access/Lesson19.htm