By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 911 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

calculating days

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

Nov 13 '05 #2

P: n/a
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.


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.