New Access user, need Help with UPDATE

[LionSkyWalker]

Hi there, I'm new with the Access, I have some experience with SQL, and this is my problem

This run correctly in SQL:

Update Tabla1 Set Campo2 =
(Select Count(*) from Tabla2)

But it doesn't work with Access... How can I make it in it??

Thanx

 

[PatHartman]

Access queries that include domain functions are not updateable. To accomplish your purpose change the count query to a make table query then run the update query by joining to the table you just made to hold the counts.

It is generally poor practice to store data that can be easily calculated in a table. As soon as the base data is changed, the calculated result becomes obsolete and there is no way to know that this happened.