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 |
#11
|
|||
|
|||
dsum problem
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" wrote in message ... 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 | |
|
|