operation my be an updatable query

[Enrique Rojas]

Hello I have this sql that triggers the abovementioned error.

UPDATE ra SET ra.Year_1_Cost = (SELECT sum(conversion*Year_1_accom) AS
year1
FROM accomfundlevels
WHERE driver_id=168 And level_id=1)
WHERE ra.driver_id=5 And ra.level_id=0;

The Select statement works fine in isolation but when I put it into the
whole statement then it gives and error in access.

"operation my be an updatable query"

Does anyone know why this is so?

Thanks in advance

[Jana]

Enrique:

I think if you remove the AS year1 from your select statement, you'll
be fine.

HTH,
Jana

Enrique Rojas wrote:

Hello I have this sql that triggers the abovementioned error.

UPDATE ra SET ra.Year_1_Cost = (SELECT sum(conversion*Year_1_accom) AS
year1
FROM accomfundlevels
WHERE driver_id=168 And level_id=1)
WHERE ra.driver_id=5 And ra.level_id=0;

The Select statement works fine in isolation but when I put it into the
whole statement then it gives and error in access.

"operation my be an updatable query"

Does anyone know why this is so?

Thanks in advance

[Enrique Rojas]

I ended up making a temp table updating it with the data I wanted then
joining it with the table i wasted to change and updated it from there.

Jana wrote:

Enrique:

I think if you remove the AS year1 from your select statement, you'll
be fine.

HTH,
Jana

Enrique Rojas wrote:

Hello I have this sql that triggers the abovementioned error.

UPDATE ra SET ra.Year_1_Cost = (SELECT sum(conversion*Year_1_accom) AS
year1
FROM accomfundlevels
WHERE driver_id=168 And level_id=1)
WHERE ra.driver_id=5 And ra.level_id=0;

The Select statement works fine in isolation but when I put it into the
whole statement then it gives and error in access.

"operation my be an updatable query"

Does anyone know why this is so?

Thanks in advance