tblFoo

FooId Name Number
1 One 1
2 Two 2
3 Three 3

The Following query produces the results I want, but it is not
updatable. I need at least the "Number" field to be updatable.

select Name, Number, (select sum(Number) from tblFoo) as TotalNumber
from tblFoo

So I tried:

select Name, Number, dsum ([Number], "tblFoo") as TotalNumber
from tblFoo

This produces:

Name Number TotalNumber
One 1 3
Two 2 6
Three 3 9

I obviously misunderstand how dsum is supposed to work and I was not
illuminated by the help file.

Any help is appreciated.

GD <gypsydweller (AT) jmjservices (DOT) com> wrote

select Name, Number, dsum ("Number", "tblFoo") as TotalNumber from
tblFoo

gives what you want, and the "Number" field is updatable (but the
TotalNumber field does not change until you re-run the query).

Rob