Results 1 to 2 of 2
  1. #1
    djpassa17 is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2013
    Posts
    1

    Question Need to pull a couple of fields from one access db to antoher for a report. Help?!

    I have two access db's and need to pull a couple of table values from one db and put them into another.


    I really need the data for a report.
    1. Can I pull the table values to from one db to another?
    2. What is the best way to do this ?

    Thanks!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    Could set a link to the other db table and use the link table just like any other table. Include it in the query for the report.
    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. Replies: 8
    Last Post: 10-23-2013, 04:37 PM
  2. Replies: 5
    Last Post: 02-05-2013, 01:18 PM
  3. One lookup to pull through multiple fields
    By simon238 in forum Access
    Replies: 13
    Last Post: 12-03-2012, 02:06 PM
  4. Multiselect to pull report from Access Form
    By Jackfam58 in forum Programming
    Replies: 3
    Last Post: 08-01-2012, 01:23 PM
  5. Need single report to pull from 2 queries
    By Nathan Plemons in forum Access
    Replies: 2
    Last Post: 03-14-2012, 11:04 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