If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
dsum problem
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'") |
#2
|
|||
|
|||
dsum problem
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'") |
#3
|
|||
|
|||
dsum problem
Already answered in another newsgroup to which you posted the same question.
-- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Alan" wrote in message ... 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'") |
#4
|
|||
|
|||
dsum problem
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'") |
#5
|
|||
|
|||
dsum problem
Well its not working this time around that why i'm asking to why
"Douglas J. Steele" wrote: Already answered in another newsgroup to which you posted the same question. -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Alan" wrote in message ... 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'") . |
#6
|
|||
|
|||
dsum problem
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'") |
#7
|
|||
|
|||
dsum problem
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'") |
#8
|
|||
|
|||
dsum problem
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'") |
#9
|
|||
|
|||
dsum problem
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'") |
#10
|
|||
|
|||
dsum problem
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" 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'") . |
|
Thread Tools | |
Display Modes | |
|
|