Need help with Update

[LionSkyWalker]

I have this SQL statement, and it works fine in SQL

Update Table1 Set Field2 =
(Select Count(*)from Table2)

But it doesn't work with Access.

Can anyone help me with this???

Thanx

 

[tlbroadbent]

Try this.

Update Table1 Set Field2 = DCount("*","Table2"
Terry

http://members.home.net/tlbroadbent/index.htm

 

[Cagliostro]

Update Table1 Set Field2 t.x
from
(Select Count(*) as x from Table2) as t John Fill

ivfmd@mail.md