Search results

I don't understand how 2007 is filter?? where is the equition of it?

i'm confusing with all the bracket!!

Yeah, i got it... but could you pls do a brief explain on it??

I'm writing a program to pass the sql to query the database so that i unable to write a module on it. Do you still have any other way to do this? i'm sorry to bordering yous o much...

if i follow this way how can query for 1-52 in 2007?? that might have duplicate data for ww52

i got a new question... what if now i would like to query a range of work week?? eg: workweek 1 to workweek 6 in year 2007

Thanks a lots... that is easy!! why i never think of it?? :confused:

how can i use the date criteria as second criteria?? the criteria must be work week and it return the date based on the work week criteria.

i'm filtering by workweek

i have make some changes on my query. my new query will be SELECT * FROM TBL WHERE FORMAT(MYDATE, 'WW yyyy', 1, 2) = '1 2007' so 31/12/2006 is fall under work week 1 in year 2007 but this record is not query out too in this statement... what i want is record from 31/12/2006 till 6/1/2007 which...

ya the query will include 2006 and 2007 record but i just want 2007 work week 1 record.

if i change to "AND YEAR(2006) OR YEAR(2007)" it will mixed up 2006 and 2007 work week 1 record.

I got a problem regarding query work week in database. The database contain data of year 2006 and 2007. When i query about work week, some record is missing. i wrote the sql statement as SELECT * FROM TBL WHERE FORMAT(MYDATE, 'WW', 1, 2) = 1 AND YEAR(2007); There is one record missing... which...