Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. 11-19-2010, 09:53 PM #16
    ConneXionLost's Avatar
    ConneXionLost
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291

    Then just add the other fields from [Sheet1] into the query, and link the query into your form as the record source.
    Reply With Quote Reply With Quote
  2. 11-19-2010, 10:07 PM #17
    jo15765's Avatar
    jo15765
    jo15765 is offline Expert
    Windows 7 Access 2000
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    672
    OMG, that is exactly what I have been trying to do!!
    Reply With Quote Reply With Quote
  3. 11-19-2010, 10:09 PM #18
    ConneXionLost's Avatar
    ConneXionLost
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    Does that mean it worked?
    Reply With Quote Reply With Quote
  4. 11-20-2010, 07:23 PM #19
    jo15765's Avatar
    jo15765
    jo15765 is offline Expert
    Windows 7 Access 2000
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    672
    Sorry, yes it worked exactly like I was needing it to! Thanks for your help.
    Reply With Quote Reply With Quote
Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. combining multiple fields and comma delimi as strings into one field using update
    By johnmerlino in forum Access
    Replies: 15
    Last Post: 10-14-2010, 12:22 PM
  2. Combining multiple Excel records into Access
    By Jadey78 in forum Import/Export Data
    Replies: 0
    Last Post: 05-04-2010, 07:51 PM
  3. Combining fields
    By cotri in forum Forms
    Replies: 2
    Last Post: 01-18-2010, 12:06 PM
  4. combining fields into a single list
    By rich in forum Queries
    Replies: 4
    Last Post: 02-23-2009, 06:41 AM
  5. Combining 2 fields from different tables into 1
    By rainxking in forum Access
    Replies: 1
    Last Post: 06-03-2006, 05:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums