ms access update problem

[guinnie]

I'm trying to update a table (67024_G03_03012004 ) by matching on the name column in another table (blanks) field. These columns are the same. I can't get it to work.
Any help would be appreciated ! Here is my SQL:


UPDATE 67024_G03_03012004
SET 67024_G03_03012004.Student_OEN = (select [blanks].[oen_number]
from [blanks]
where
[67024_G03_03012004].[StudentName]=[Blanks].[StudentName]);

[Rabbit]

What error are you getting? What results are you getting?

[guinnie]

What error are you getting? What results are you getting?

It first asks me for input parameters (which I wasn't expecting) but when I put in a value the error message says 'operation must be an updateable query'.

[Rabbit]

It first asks me for input parameters (which I wasn't expecting) but when I put in a value the error message says 'operation must be an updateable query'.

What parameter is it asking you to define?

Usually a parameter when you don't expect one means you've mispelled a table name or field name.

[guinnie]

What parameter is it asking you to define?

Usually a parameter when you don't expect one means you've mispelled a table name or field name.

Currently, I just need to know if the syntax of the update command is correct ?
This would help greatly.

[pradeep kaltari]

I'm trying to update a table (67024_G03_03012004 ) by matching on the name column in another table (blanks) field. These columns are the same. I can't get it to work.
Any help would be appreciated ! Here is my SQL:


UPDATE 67024_G03_03012004
SET 67024_G03_03012004.Student_OEN = (select [blanks].[oen_number]
from [blanks]
where
[67024_G03_03012004].[StudentName]=[Blanks].[StudentName]);

Hi,
The syntax of UPDATE seems to be correct but make sure that the sub-query returns only one row.

Pradeep

[MMcCarthy]

I would actually change it as follows:

 
UPDATE 67024_G03_03012004 INNER JOIN [Blanks] 
ON [67024_G03_03012004].[StudentName]=[Blanks].[StudentName]
SET 67024_G03_03012004.Student_OEN = [blanks].[oen_number]