Prev: Counting number of records based on criteria
Next: Reminder - Microsoft Responds to the Evolution of Community
From: Douglas J. Steele on 21 May 2010 11:55
Do you mean you want records where [Revenue Stream Division] is 'Production'
and you also want records where [Revenue Stream Division] is 'Other'?

And [Revenue Stream Division] IN ('Production', 'Other')")

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

"Alan" <Alan(a)discussions.microsoft.com> wrote in message
news:124F8D40-EABD-48ED-BD57-69B8F5A0F885(a)microsoft.com...
>
> And [Revenue Stream Division] = 'Production'")
>
> thank very much just one last thing
>
> how do i get the code at top to look at "production" and "other"
>
> "Douglas J. Steele" wrote:
>
>> 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" <Alan(a)discussions.microsoft.com> wrote in message
>> news:128AA506-95AD-47E6-B668-B14A43970D09(a)microsoft.com...
>> > 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'")
>>
>>
>> .
>>


First  |  Prev  | 
Pages: 1 2 3
Prev: Counting number of records based on criteria
Next: Reminder - Microsoft Responds to the Evolution of Community