Results 1 to 2 of 2
  1. #1
    DeviceAgent is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jun 2015
    Posts
    1

    Build a query to pull data from one table and insert into another table

    I want to build a query that will search for a employee ID in one table and insert the data associated with the employee ID into another table then build a form to run the query. any ideas?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    create an append query. pull down your table to search in, in criteria add a param [Enter Search ID]
    set the table to append the data

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

Similar Threads

  1. Replies: 5
    Last Post: 12-01-2014, 11:31 AM
  2. Insert Data from one table to another Query
    By zipaway in forum Queries
    Replies: 3
    Last Post: 07-28-2014, 10:15 AM
  3. Insert Into Query With Table data and values
    By WickidWe in forum Queries
    Replies: 1
    Last Post: 01-05-2014, 06:41 PM
  4. Replies: 8
    Last Post: 11-25-2013, 03:35 PM
  5. Query to pull multiples of same data from a table
    By mpreston14 in forum Queries
    Replies: 1
    Last Post: 05-24-2013, 02:01 AM

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