Update error.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
When I try to updata a table, it just jumps an error box telling me "Operation must use an updateable query". I wander what was wrong. My SQL is below
UPDATE bzt_project
se
a.per=(
select sum(percentage) from bzt_percentag
)
where DateDiff('m', a.首期款日期, #"+myDate+"#) =
Could u plase tell me why and how to correct it?
 
Hi,
When I try to updata a table, it just jumps an error box telling me "Operation must use an updateable query". I wander what was wrong. My SQL is below:
UPDATE bzt_project a
set
a.per=(
select sum(percentage) from bzt_percentage
),
where DateDiff('m', a.?????, #"+myDate+"#) = 0
Could u plase tell me why and how to correct it?

Any query that includes a Sum or other aggregate function - even one
like this, which logically *should* be updateable - is not. Access
just has this annoing limitation.

You can get around it by setting a.per to

DSum("[percentage]", "[bzt_percentage]")

I'm not sure what your ????? is but that shouldn't affect this
particular problem!
 
Back
Top