Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007

    Append or Update Query - Issues creating criteria/expression

    I am trying to build a query in my MS Access database. I am operating on Office 2000. I have 2 tables that I am working with. Both tables contain columns with identical information. These identical fields are currently linked together as a subdatasheet under tables. What I would like to do is create a query where, if the data from one table is identical to data in another table, then values are copied and pasted in to the main table.

    Here is what I am talking about:

    I have 2 tables:
    1 = ISMCompany
    2 = BPIncCompany

    Both tables contain the identical fields "DepartmentName." I am trying to bring data from table 2 over to table 1 and paste information from table 2 in the columns if the "DepartmentName" fields in both tables are identical. I would think this would be a simple task:

    Create an append query and append data to table 1 where the criteria is as follows:

    "If [ISMCompany]![DepartmentName] = [BPIncCompany]![DepartmentName]"

    I am pulling my hair out and have been trying to figure this out for over 12 hours now. Someone, please please help! It seems like it would be a simple problem to fix, but I just can't figure it out and I am going crazy! :?

  2. #2
    Gerry is offline Rusty Developer
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Kings Mountain, NC
    If you're trying to fill in fields in existing records, you don't need an append query - you need an update query. If' I've misunderstood your aim, please clarify it, and I'll try to help.

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

Similar Threads

  1. Query Criteria
    By Texaine in forum Queries
    Replies: 1
    Last Post: 01-24-2018, 02:36 PM
  2. Query Criteria
    By jena in forum Access
    Replies: 1
    Last Post: 08-03-2008, 04:08 AM
  3. Query Criteria
    By jena in forum Queries
    Replies: 1
    Last Post: 04-29-2008, 11:00 AM
  4. Query expression for form
    By pjacob in forum Forms
    Replies: 1
    Last Post: 10-10-2006, 09:12 PM
  5. Replies: 0
    Last Post: 12-05-2005, 04:09 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