ACCESS 2007 Update Queries   

I just updated and am trying to make an UPDATE QUERY like I did in Access 2003.
When I try to update the value in one table with the value from another 
table I get a message that says I can only use one table and when one is 
selected the other table is removed.  How do I make this type query in Access 
2007

date: Fri, 26 Sep 2008 17:52:03 -0700   author:   Tom

RE: ACCESS 2007 Update Queries   

My mistake, 2007 works the same as 2003, I was thinking of a different Access 
project (.mdb) from the past. 

"Tom" wrote:

> I just updated and am trying to make an UPDATE QUERY like I did in Access 2003.
> When I try to update the value in one table with the value from another 
> table I get a message that says I can only use one table and when one is 
> selected the other table is removed.  How do I make this type query in Access 
> 2007

date: Sat, 27 Sep 2008 18:55:00 -0700   author:   Tom