You still haven't corrected the quotes. And must be inside the quotes, not
outside them.

=DSum("[AmountActual]","[Sales Analysis]","[Posting Date Period] = '" &
[cbMonth] & "' And [Revenue Stream Division] = 'Production'")

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Alan" wrote in message
...
Hi

=DSum("[AmountActual]","[Sales Analysis]","[Posting Date Period] = '" &
[cbMonth] & "'" And "[Revenue Stream Division] = 'Production'")

The posting date period is correct but soon as i add in

"[Revenue Stream Division] = 'Production'")

it just give the a value not specific to that posting period date

thanks in advance

"Alan" wrote:

Can someone tell me what wrong with my dsem as the cbmonth is not working

=DSum("[AmountActual]","Sales Analysis","[Posting Date Period] = '" &
[cbmonth] & "'" And "Revenue stream divsion = 'Production'" And "Type =
'Actual'")