To further explain because I'm not always clear in what I'm trying to achieve. I need to bring in "one" column from a 2008 terms file and match by vendor ID into 2009 terms file table. I was successful in creating queries to get same terms and no change terms, but now I need all terms in one file showing before and after . . . but again, I only need to bring in one field to display side-by-side in the 2009 file. If it can't be done in Access, I suppose I can do a match statement in Excel and import it in to Access. I appreciate any suggestions