Recent content by Franky27

Thanks Thanks Thanks HiTechCoach, Great it works perfect thanks

I upload a example database with the 2 tables and made an extra yable how the result of the query should look like. Hope this will be clear enough Thanks

Im trying to manage next thing Table 1 (Season) ID | startdate | End date | description 1 2006-09-01 | 2007-08-31 | Season 2007 2 2007-09-01 | 2008-08-31 | Season 2008 3 2008-09-01 | 2009-08-31 | Season 2009 4 2009-09-01 | 2010-08-31 | Season 2010 Table 2...

thanks a lot vbaInet, Great help. Im working it out now

Ok I mean. I want to find the price in this query Product | date| price 1 2010-08-09 ? get price out of this table Product | from | till | price 1 | 2007-01-01 | 2008-12-31 | 10 1 | 2008-01-01 | 2009-12-31 | 11 august 8th 2010 is not in 1 of the from - till range so...

I cant find out next I have a table like this Product from till price 1 2007-01-01 2008-12-31 10 1 2008-01-01 2009-12-31 11 In a query I want to match this Product...