Results 1 to 4 of 4
  1. #1
    mp6453 is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2020
    Posts
    1

    Append query with multivalue (attachment) field

    I'm trying to create an append query for table A to table B, but of course it's not so easy with multivalue fields.



    I'll use an example here where I have two identical tables, table A and B. The only field in each table is a multivalue (attachment) field. Btw, I know seasoned programmers prefer to avoid multivalue fields, but this is what I'm working with.

    Click image for larger version. 

Name:	tbl_A_B.png 
Views:	11 
Size:	3.9 KB 
ID:	42327


    How would one accomplish this? From what I'm reading I think it takes two queries with an inner/outer join, but I don't know how to do that.

    Thanks!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    i think a single append will do this.
    you only need 2 queries just to EXTRACT whats in the attch fld.

  3. #3
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    Btw, I know seasoned programmers prefer to avoid multivalue fields, but this is what I'm working with.
    Not only do we avoid using multivalue fields, we especially avoid using attachments fields.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Hope you understand that a multi-value or attachment field involves a hidden table where the data/objects are actually stored.

    An attachment field does allow multiple elements and is therefore a type of multi-value field but it is different because it is saving objects, not just alpha-numeric data.

    Attachment field has properties: FileData, FileName, FileType
    Regular multi-value field has property: Value

    I tried various SQL structures for each type of field in attempt to create new records in table B. Nothing works.
    It would be easier to just copy the table.

    Maybe your example is too simplified. Why would you want identical tables?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Multivalue Field Query
    By bucgatorfan in forum Queries
    Replies: 2
    Last Post: 02-15-2018, 12:46 PM
  2. Append Query with an Attachment Field
    By KH Ahmed Bara in forum Queries
    Replies: 0
    Last Post: 04-09-2016, 04:18 AM
  3. Replies: 3
    Last Post: 09-21-2013, 09:56 PM
  4. Problem with append query for attachment field
    By ahmadrezaahmad in forum Queries
    Replies: 9
    Last Post: 06-29-2013, 09:08 PM
  5. Append into multivalue field help
    By iwantatransam in forum Import/Export Data
    Replies: 0
    Last Post: 04-26-2011, 08:11 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums