on 10-16-2008 5:03 PM
Hi guys
we have a query here of sales which have a variable of calender month
if we are passing three intervals i.e 01.2006 - 03.2006 , 01.2007 - 03.2007 , 01.2008 - 03.2008 and in still its showing some value of 01.2005 in query output whichi is very minimal ( 0.17) . this is happening only for this interval other intervals or single values i have tried all are showing correct. i am astonished how its happening. guys any clue .
Regards
Amiya
Edited by: Amiya Rath on Oct 16, 2008 6:03 PM
how do you display the results? in a workbook? if so, check the query properties once the workbook has run... if someone has put a filter in there and saved the workbook, it remains there (without being very obvious)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.