Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2009
    Posts
    1

    Unanswered: Populate data in a table with data from another table

    Hi all,
    I have two tables in one database. "Teachers" contains (amongst other things) a list of 400 unique ID numbers. "URated" contains a list of 50 ID numbers. I use Access 2007.

    What I would like to do is have the word "Yes" appear in the field "Rating" in the Teachers table for each ID in "Teachers" that also appears in "URated". So, every time "ID in Teachers" = "ID in URated", I want the word Yes to appear in Rating in Teachers.

    TIA!
    -A

    UPDATE: I figured it out, nevermind!
    Last edited by thebuffster; 07-24-09 at 18:07.

Posting Permissions

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