Troubles with update

[LionSkyWalker]

Hi there.

I'm having troubles with some updates, but here is the first:

How can I update a Field, that get the value from a Count statement between 2 tables? Here's what I'm trying to do:


Update TableX Set Field1 = (
SELECT Count(*) FROM Table1 INNER JOIN Table2 ON Table1.ses_id = Table2.ses_id WHERE Table1.status In ('E','A'))

I hope someone could help me...

 

[Tim1]

Hiya,

Why don't you try:

SELECT tempField1 = SELECT Count(*) FROM Table1 INNER JOIN Table2 ON Table1.ses_id = Table2.ses_id WHERE Table1.status In ('E','A'))


Update TableX Set Field1 = tempField1


Tim

 

[tlbroadbent]

You should explain the problem. Does the query give an error? Is it failing to update as expected? Just exectly what is the problem? Terry

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

 

[LionSkyWalker]

That update works fine in SQL, but does not in Access. In access just says that it must use a query updatable...

Or how can I do it in a Form in access instead than a query???

 

[tlbroadbent]

The query as written in yor first post would update Field1 on all records in tableX with the same value. Is that what you wish to do? Or do youu have some criteria for selecting records to update in tableX? Terry

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