Recent content by Toto

stopher, you are genius ! How to learn this techniques ?

It does not work. Tbl1 : "dd aa"; "ee ff"; "bb gg" .Tbl2 : "aa"; "bb" . The results should be "ee ff". Query returns : "dd aa"; "ee ff"; "ee ff";"bb gg"

I have the table tbl1 which contains the phrases and another table tbl2 with the words. I should create the List Box with the phrases from tbl1 which does not contain any word from tbl2. What would be the simplest solution ?

I think that SQL query select max(end) - min(start) NumberofDays from table calculates only number of days between first start date and last end date. Result is 108 (wrong). I found out another method. I created the calendar table and 3 query.The first one creates a crosstab of all dates...

Thank you, this expression calculates the number of days, but does not excludes the overlapped periods . I found a similar question and the solution in the SQL Server forum: h...

Day does not have to be counted twice, then it is in the overlapping date ranges. Sorry, my table : ID Start End 1 2013.11.20 2014.01.10 2 2014.01.17 2014.01.30 3 2014.01.06 2014.01.27 4 2014.02.04 2014.02.23 5 2014.02.07 2014.02.17 6 2014.02.21 2014.03.08

Hello, Please help me ! My table : Id Start End 1 2013.11.20 2014.01.10 2 2014.01.17 2014.01.30 3 2014.01.06 2014.01.27 4 2014.02.04 2014.02.23 5 2014.02.07 2014.02.17 6 2014.02.21 2014.03.08 How to calculate total number of unique days? Date ranges are...