title: Query Access Table by a column from another Table
body: <p>I am a definite beginner with anything beyond the basics of Access. I'm having an issue figuring a way to Query a Table with fields from another Table.  I have Two tables in Access, one has any Invoice with an open balance.  The other has a list of invoices where the invoices need to be adjusted.  I'm going to run a program that adjusts these invoices, so Ideally the invoices in table 2 will in table 1 today and will be gone tomorrow.  Is there a way to query table 1 by all the invoices in table 2 so I can make sure that they are all off table 1 tomorrow?</p>
  
  <p>Any help would be greatly appreciated!!</p>