What is wrong with the following query

update regeneration set regenertion.[14TH COLLECT HEIGHT (CM) JUN/2002]
(select try2.[14TH COLLECT HEIGHT (CM) JUN/2002] from try2,regeneration 
where regeneration.[Cell] = try2.[Cell] and regeneration.[Plot] = try2.
[Plot] and regeneration.[ID #] = try2.[ID #])


"no value given to one or more required parameters" is the error that I 
get.

simplified version of the above query is this:

update table1 set table1.[col1] = (select table2.[col1] from table1,table2 
where table1.[col5]=table2.[col5])

my first thought is that Access is misinterpreting one of your field names
as a function call.  In my opinion, simpler field names make life easier.
CELL is a function name. 

also I think, and maybe I am wrong here, but if you might need to remove the
regeneration table from the FROM list in the subquery.



-----Original Message-----
From: Rahul Alavalapati [mailto:arahul2@u...]
Sent: Thursday, August 22, 2002 1:12 PM
To: Access
Subject: [access] Query Problem


What is wrong with the following query

update regeneration set regenertion.[14TH COLLECT HEIGHT (CM) JUN/2002]
(select try2.[14TH COLLECT HEIGHT (CM) JUN/2002] from try2,regeneration 
where regeneration.[Cell] = try2.[Cell] and regeneration.[Plot] = try2.
[Plot] and regeneration.[ID #] = try2.[ID #])


"no value given to one or more required parameters" is the error that I 
get.

simplified version of the above query is this:

update table1 set table1.[col1] = (select table2.[col1] from table1,table2 
where table1.[col5]=table2.[col5])

Create a new query and paste this part into the SQL and see if it returns
any records:

select try2.[14TH COLLECT HEIGHT (CM) JUN/2002] from try2, regeneration
where regeneration.[Cell] = try2.[Cell] and regeneration.[Plot] = try2.
[Plot] and regeneration.[ID #] = try2.[ID #]

By the way, it looks like the query will set all [14TH COLLECT HEIGHT (CM)
JUN/2002] rows to the same value
since there is no where clause on which rows will be updated in
regeneration.

|-----Original Message-----
|From: Rahul Alavalapati [mailto:arahul2@u...]
|Sent: Thursday, August 22, 2002 6:12 PM
|To: Access
|Subject: [access] Query Problem
|
|
|What is wrong with the following query
|
|update regeneration set regenertion.[14TH COLLECT HEIGHT (CM) JUN/2002]
|(select try2.[14TH COLLECT HEIGHT (CM) JUN/2002] from try2,regeneration
|where regeneration.[Cell] = try2.[Cell] and regeneration.[Plot] = try2.
|[Plot] and regeneration.[ID #] = try2.[ID #])
|
|
|"no value given to one or more required parameters" is the error that I
|get.
|
|simplified version of the above query is this:
|
|update table1 set table1.[col1] = (select table2.[col1] from table1,table2
|where table1.[col5]=table2.[col5])
|

You misspelled the second regeneration.  I'm assuming you copy/pasted this
to the list and didn't try typing it in.  If you typed it in and just made
an error on this list, then ignore my comment.


Andrew

-----Original Message-----
From: Carnley, Dave [mailto:dcarnley@a...]
Sent: Thursday, August 22, 2002 2:26 PM
To: Access
Subject: [access] RE: Query Problem


my first thought is that Access is misinterpreting one of your field names
as a function call.  In my opinion, simpler field names make life easier.
CELL is a function name.

also I think, and maybe I am wrong here, but if you might need to remove the
regeneration table from the FROM list in the subquery.



-----Original Message-----
From: Rahul Alavalapati [mailto:arahul2@u...]
Sent: Thursday, August 22, 2002 1:12 PM
To: Access
Subject: [access] Query Problem


What is wrong with the following query

update regeneration set regenertion.[14TH COLLECT HEIGHT (CM) JUN/2002]
(select try2.[14TH COLLECT HEIGHT (CM) JUN/2002] from try2,regeneration
where regeneration.[Cell] = try2.[Cell] and regeneration.[Plot] = try2.
[Plot] and regeneration.[ID #] = try2.[ID #])


"no value given to one or more required parameters" is the error that I
get.

simplified version of the above query is this:

update table1 set table1.[col1] = (select table2.[col1] from table1,table2
where table1.[col5]=table2.[col5])

There is also an extra space in try2. [Plot], unless of course this was just
typed and not a cut and paste.

Beth 
-----Original Message-----
From: Andrew Cooper [mailto:aecooper@i...] 
Sent: Thursday, August 22, 2002 1:44 PM
To: Access
Subject: [access] RE: Query Problem

You misspelled the second regeneration.  I'm assuming you copy/pasted this
to the list and didn't try typing it in.  If you typed it in and just made
an error on this list, then ignore my comment.


Andrew

-----Original Message-----
From: Carnley, Dave [mailto:dcarnley@a...]
Sent: Thursday, August 22, 2002 2:26 PM
To: Access
Subject: [access] RE: Query Problem


my first thought is that Access is misinterpreting one of your field names
as a function call.  In my opinion, simpler field names make life easier.
CELL is a function name.

also I think, and maybe I am wrong here, but if you might need to remove the
regeneration table from the FROM list in the subquery.



-----Original Message-----
From: Rahul Alavalapati [mailto:arahul2@u...]
Sent: Thursday, August 22, 2002 1:12 PM
To: Access
Subject: [access] Query Problem


What is wrong with the following query

update regeneration set regenertion.[14TH COLLECT HEIGHT (CM) JUN/2002]
(select try2.[14TH COLLECT HEIGHT (CM) JUN/2002] from try2,regeneration
where regeneration.[Cell] = try2.[Cell] and regeneration.[Plot] = try2.
[Plot] and regeneration.[ID #] = try2.[ID #])


"no value given to one or more required parameters" is the error that I
get.

simplified version of the above query is this:

update table1 set table1.[col1] = (select table2.[col1] from table1,table2
where table1.[col5]=table2.[col5])