calculating days

[J.J.]

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.

[PC Datasheet]

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.

[J.J.]

the week is begining 07/08 and ending 14/08
but it must count 7 days (7,8,9,10,11,12,13/08) and in the next saison also
"PC Datasheet" <no****@nospam.spam> wrote in message
news:%J*******************@newsread3.news.atl.eart hlink.net...

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.