On 24 mei, 12:51, Alan 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