Update query question

[Sunny]

can I do like this?

UPDATE mytable SET myfield = (SELECT uniquevalue FROM othertable WHERE
somecondtion) WHERE fieldid = givenvalue

In select statement there will be always one value.

Thanks.

 

[Duane Hookom]

I'm not sure if Access SQL supports an update using a subquery. I know that
you could use:

UPDATE mytable SET myfield = DLookup("uniquevalue", "Othertable",
"somecondition") WHERE fieldid = givenvalue

 

[Sunny]

Thanks Duane, that will work.

I'm not sure if Access SQL supports an update using a subquery. I know that
you could use:

UPDATE mytable SET myfield = DLookup("uniquevalue", "Othertable",
"somecondition") WHERE fieldid = givenvalue