By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,241 Members | 733 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,241 IT Pros & Developers. It's quick & easy.

DSum Question

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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


Nov 12 '05 #3

P: n/a
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

Nov 12 '05 #4

P: n/a

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]")


Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.