DSUM Syntax

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JethroUK - 22 Oct 2005 12:50 GMT

Can someone check my syntax please:

textbox control source: =DSum("[Session]","Clients","[session]='AM'")

Tablename 'Clients'
Field 'Session'
Where session = "AM"

Reply to this Message

Rick Brandt - 22 Oct 2005 13:14 GMT

> Can someone check my syntax please:
>
[quoted text clipped - 3 lines]
> Field 'Session'
> Where session = "AM"

The syntax is fine, but what does the sum of "AM" look like? You can't add
words. I suspect that one of those field names was intended to be something
else.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

JethroUK - 22 Oct 2005 14:22 GMT

>> Can someone check my syntax please:
>>
[quoted text clipped - 7 lines]
> add words. I suspect that one of those field names was intended to be
> something else.

I thought i could include criteria - in this case only count session where
they = "AM"

Think i've answered my own question here - i shouldn't be summing at all - i
should be counting :o)

Reply to this Message

Jeff Boyce - 22 Oct 2005 13:30 GMT

Why? What (?error) message are you getting?

Signature

Regards

Jeff Boyce
<Office/Access MVP>

> Can someone check my syntax please:
>
[quoted text clipped - 3 lines]
> Field 'Session'
> Where session = "AM"

Reply to this Message