Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    56

    Unanswered: Simple update query, but dont know how

    This should be easy I am sure but I am still learning access 2003.

    I have 2 tables, In table A I created a field called "Sales Office" within Table B is the actual data in a field called Office.

    I created an update query brought in Table A and B, linked the tables:

    Sales Office <---> Office

    in the design grid I have Sales Office within "Field" and in the update field I have "Office" plugged in from table B. Now when I click "View" its not populating Table B "office" data into Table A "Sales Office Field.

    What am I doing wrong?


    Thank you ahead of time.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    You gotta run it ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    On the ToolBar there should be what looks like an Exclamation Point. Click that to run your query. OR in the MenuBar select Query and then RUN.

    that's about it

Posting Permissions

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