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
|
|||
|
|||
can someone tell me where my formula going wrong V2
=DSum("[Amount6a6fs]","[Sales Analysis]","[Posting Date Period] = '" &
[cbMonth] & "' And [Revenue Stream Division] = 'Production' or [Revenue Stream Division] = 'other' And ([Customer No] = 'C01317')") every works apart from the last par customer no, the table name is correct spelling, the sun i'm getting is for everything not that specifc customer. |
Thread Tools | |
Display Modes | |
|
|