Prev: Progress Bar In Report
Next: can someone tell me where my formula going wrong V2
From: Alan on 24 May 2010 05:15


can some please tell what wrong with my dsum

=DSum("[Amount6a6fs]","[Sales Analysis]","[Posting Date Period] = '" &
[cbMonth] & "' And [Revenue Stream Division] = 'Postage'" And "'([customer
no] = 'IC0008' or [customer no] = 'C01105' or [customer no] = 'C00785' or
[customer no] = 'C01388' or [customer no] = 'IC0003' or [customer no] =
'C01317')")

thanks
From: RonaldoOneNil on 24 May 2010 05:59
Take out the quotes and the apostrophe in this middle of this section
.... [Revenue Stream Division] = 'Postage' And ([customer no] = ...

"Alan" wrote:

>
>
> can some please tell what wrong with my dsum
>
> =DSum("[Amount6a6fs]","[Sales Analysis]","[Posting Date Period] = '" &
> [cbMonth] & "' And [Revenue Stream Division] = 'Postage'" And "'([customer
> no] = 'IC0008' or [customer no] = 'C01105' or [customer no] = 'C00785' or
> [customer no] = 'C01388' or [customer no] = 'IC0003' or [customer no] =
> 'C01317')")
>
> thanks
From: XPS35 on 24 May 2010 05:59
=?Utf-8?B?QWxhbg==?= wrote:

>
>
>
> can some please tell what wrong with my dsum
>
> =DSum("[Amount6a6fs]","[Sales Analysis]","[Posting Date Period] = '" &
> [cbMonth] & "' And [Revenue Stream Division] = 'Postage'" And "'([customer
> no] = 'IC0008' or [customer no] = 'C01105' or [customer no] = 'C00785' or
> [customer no] = 'C01388' or [customer no] = 'IC0003' or [customer no] =
> 'C01317')")
>
> thanks

Hard te tell without any further information.

Do you get an error? If so, which?
Is the result no what you expect?

One thing could be [Posting Date Period]. What type is it?

--
Groeten,

Peter
http://access.xps350.com

From: Alan on 24 May 2010 06:51

its kind of work but the last part doesn't p compile as i just getting the
total value for that month and not specific customer

"XPS35" wrote:

> =?Utf-8?B?QWxhbg==?= wrote:
>
> >
> >
> >
> > can some please tell what wrong with my dsum
> >
> > =DSum("[Amount6a6fs]","[Sales Analysis]","[Posting Date Period] = '" &
> > [cbMonth] & "' And [Revenue Stream Division] = 'Postage'" And "'([customer
> > no] = 'IC0008' or [customer no] = 'C01105' or [customer no] = 'C00785' or
> > [customer no] = 'C01388' or [customer no] = 'IC0003' or [customer no] =
> > 'C01317')")
> >
> > thanks
>
> Hard te tell without any further information.
>
> Do you get an error? If so, which?
> Is the result no what you expect?
>
> One thing could be [Posting Date Period]. What type is it?
>
> --
> Groeten,
>
> Peter
> http://access.xps350.com
>
> .
>
From: Bob Quintal on 24 May 2010 07:14
=?Utf-8?B?QWxhbg==?= <Alan(a)discussions.microsoft.com> wrote in
news:11CD272B-0922-41AC-BA99-54376C2CDBD9(a)microsoft.com:

>
>
> can some please tell what wrong with my dsum
>
> =DSum("[Amount6a6fs]","[Sales Analysis]","[Posting Date Period] =
> '" & [cbMonth] & "' And [Revenue Stream Division] = 'Postage'" And
> "'([customer no] = 'IC0008' or [customer no] = 'C01105' or
> [customer no] = 'C00785' or [customer no] = 'C01388' or [customer
> no] = 'IC0003' or [customer no] = 'C01317')")
>
> thanks

several issues, mostly with quote symbols,in the [customer no]
criteria. using the IN method simplifies that.
Also note that the quote marks around cbmonth indicate a text type for
[Posting Date Period]. If it is a number, remove the single quote
before [cbmonth] and after. Also if cbmonth is a control on a form, you
may have a problem unless you specify the name of the form, as
Forms!myForm!cbMonth instead of [cbMonth] (change myForm to your form's
name)

This should work

=DSum("[Amount6a6fs]", "[Sales Analysis]",
"[Posting Date Period] = '" & [cbMonth] & "'
And [Revenue Stream Division] = 'Postage'
And [customer no] IN
('IC0008','C01105','C00785','C01388','IC0003','C01317')")
 |  Next  |  Last
Pages: 1 2
Prev: Progress Bar In Report
Next: can someone tell me where my formula going wrong V2