Prev: Progress Bar In Report
Next: can someone tell me where my formula going wrong V2
From: XPS350 on 24 May 2010 07:25
On 24 mei, 12:51, Alan <A...(a)discussions.microsoft.com> wrote:
> 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
>
> > .

A least there is an & missing in:
.... [Revenue Stream Division] = 'Postage'" And "'([customer no] =...


Groeten,

Peter
http://access.xps350.com
From: John Spencer on 24 May 2010 09:35
=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')")

A little bit easier to read would be

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



John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

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
First  |  Prev  | 
Pages: 1 2
Prev: Progress Bar In Report
Next: can someone tell me where my formula going wrong V2