DSum Question

[John Baker]

Hi:

I have a form, and wish to show on the form the current total for a single field on a
table. I have set this up thus: =DSum([Total],[table]![tbltimesheetsnew]) in an unbound
text field. These are correct field and table names. While the formulation is accepted by
the system, nothing appears in the field and no results show up at all. I tried a number
of combinations with no success. Can someone tell me what I am doing wrong?

Thanks

John Baker

[MacDermott]

The arguments for DSum are strings, thus:
=DSum("[Total]","tbltimesheetsnew")

HTH
- Turtle

"John Baker" <Ba******@Verizon.net> wrote in message
news:1o********************************@4ax.com...

Hi:

I have a form, and wish to show on the form the current total for a single field on a table. I have set this up thus: =DSum([Total],[table]![tbltimesheetsnew]) in an unbound text field. These are correct field and table names. While the formulation is accepted by the system, nothing appears in the field and no results show up at all. I tried a number of combinations with no success. Can someone tell me what I am doing wrong?
Thanks

John Baker

[John Baker]

Thanks:

OK

Set it up:
=DSum("[Travel$]","[tbltimesheetsnew]")

and still wont work. I tried putting [Table]! in front of the sheet name, but no joy
there.

This will work on a form wont it?

My concern is that I am using the experssion builder, and when i click OK nothing appears
in the unbound field.

Any other suggetions?

JOhn

"MacDermott" <ma********@nospam.com> wrote:

The arguments for DSum are strings, thus:
=DSum("[Total]","tbltimesheetsnew")

HTH
- Turtle

"John Baker" <Ba******@Verizon.net> wrote in message
news:1o********************************@4ax.com.. .

Hi:

I have a form, and wish to show on the form the current total for a single

field on a

table. I have set this up thus: =DSum([Total],[table]![tbltimesheetsnew])

in an unbound

text field. These are correct field and table names. While the formulation

is accepted by

the system, nothing appears in the field and no results show up at all. I

tried a number

of combinations with no success. Can someone tell me what I am doing

wrong?

Thanks

John Baker

[YFS DBA]

John,

I set up a table called "tbltimesheetsnew" with the following field name:
'Total", formatted as Number.

I then created a form with this DSUM function:

=DSum("[Total]","[tbltimesheetsnew]")

It sums correctly - try it.

HTH
"John Baker" <Ba******@Verizon.net> wrote in message
news:1o********************************@4ax.com...

Hi:

I have a form, and wish to show on the form the current total for a single field on a table. I have set this up thus: =DSum([Total],[table]![tbltimesheetsnew]) in an unbound text field. These are correct field and table names. While the formulation is accepted by the system, nothing appears in the field and no results show up at all. I tried a number of combinations with no success. Can someone tell me what I am doing wrong?
Thanks

John Baker

[John Baker]

Thanks, that works.

From hacking round it appears that when I use the "Build Event" capability on an unbound
field, the resulting code does not go directly intro the field when I click Ok. Rather, I
have to copy it and paste it into the field in question. One of those niggling things that
frustrated the newby!

Thanks again

John Baker
"YFS DBA" <Ny**********@prexar.com> wrote:

=DSum("[Total]","[tbltimesheetsnew]")