The first problem you need to resolve is that you have overlapping saisons.

14/08 falls in both the first saison and the second saison. In your second

example where guests arrived 07/08 and departured 21/08, Access will need a way

to know that 14/08 is in the second saison. You also need to be consistent about

this. If guests arrived 07/08 and departured 14/08, it's six days in the first

saison and 1 day in the second saison.

--

PC Datasheet

Your Resource For Help With Access, Excel And Word Applications

re******@pcdatasheet.com www.pcdatasheet.com
"J.J." <no****@jj.com> wrote in message news:cf**********@ls219.htnet.hr...

hi

I have a table with saison_Id, saison_begin and saison_end in which i have 9

records or 9 saisons. in secodnd table i enter guest_id, guest_name,

guest_arrival and guest_departure.

now i need to calculates how many days did the guest stayed by saisons.

example:

first saison is form 17/07 till 14/08

second saison is form 14/08 till 21/08

so if the guest arrived 24/07 and departured 31/07 then it's 7 days in first

saison

or if the guests arrived 07/08 ad departured 21/08 then it's 7 days in first

and 7 days in sacond saison.

any suggestion how should i solve this problem

thanks in advance

J.J.