Update table with SQL

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

I have a SQL query that works fine on an SQL server database but not on an
equivalent Access database. Can anyone please help me tune the query to
function in Access?
The query looks like this:

update TABLE1 set Column1 = (select count(*) from TABLE2 where("Column2"=2))

/Roger


.

Relevant Pages