Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update problem

Status
Not open for further replies.
schu

schu

MIS
Jun 21, 2001
188
HK
I would like to perform the following update statement in access, how do I do it

update table1 set field1 = (select count(*) from table2
where table1.fieldx = table2.fieldx and table2.fieldy = ???)
where table1.field2 = ???


??? are parameters

please help
thank you
 
Status
Not open for further replies.

Similar threads

MattGreer
  • Locked
  • Question
Can't update a field from a query result due to 'Group By'
Replies
2
Views
253
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Using Domain Aggregate expression in Update Query 2
Replies
12
Views
474
TheresAlwaysAWay
TheresAlwaysAWay
puforee
  • Locked
  • Question
Query update issue
Replies
5
Views
333
Andrzejek
Andrzejek
JoPaBC
  • Locked
  • Question
Update data directly in select query recordset 1
Replies
10
Views
469
JoPaBC
JoPaBC
puforee
  • Locked
  • Question
Update Query not working 1
Replies
6
Views
314
puforee
puforee

Part and Inventory Search

Sponsor

Back
Top