Prev: Counting number of records based on criteria
Next: Reminder - Microsoft Responds to the Evolution of Community
From: Alan on 20 May 2010 11:04
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'")
From: Douglas J. Steele on 20 May 2010 11:14
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'")


From: RonaldoOneNil on 20 May 2010 11:32
You extra double quotes where you don't need them

..... [cbMonth] & "' And [Revenue Stream Division] = 'Production'")

"Alan" wrote:

> 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'")
From: Daryl S on 20 May 2010 12:29
Alan -

To reference the selected value in a combo-box, include the column you need
(column 0 is the first column, etc.). Since you have single quotes around
it, I assume this value is text (use your form name).

Forms![YourFormName]![cbmonth].Column(0)


--
Daryl S


"Alan" wrote:

> cbmonth is a combo box with is bound to table sales analysis "posting Date
> Period", the format is 2010/07 not sure if its text or date??
>
> i put in the ME. function and i get #?Name error, if i leave it out i get a
> value but wrong total
>
> "Daryl S" wrote:
>
> > Alan -
> >
> > Any field names, table names, etc. with spaces or special characters need to
> > be surrounded by square brackets:
> >
> > Also, what is [cbmonth]? Is it a control on a form? If so, it should be
> > either Me.[cbmonth] (if the code is on the form), or
> > Forms![YourFormName]![cbmonth] (if referred to outside the form).
> >
> > =DSum("[AmountActual]","[Sales Analysis]","[Posting Date Period] = '" &
> > [cbmonth] & "'" And "[Revenue stream divsion] = 'Production'" And "[Type] =
> > 'Actual'")
> >
> > If you still have issues, tell us what [cbmonth] is so we can help with the
> > syntax...
> >
> > --
> > Daryl S
> >
> >
> > "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'")
From: Alan on 21 May 2010 06:39

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  |  Next  |  Last
Pages: 1 2 3
Prev: Counting number of records based on criteria
Next: Reminder - Microsoft Responds to the Evolution of Community