J
J.J.
Hi
i have tables: Saison_TBL and Price_TBL, Person_TBL. The first one has 3
fields: Saison_ID, Saison_Start and Saison_End. The second: Price_ID,
Saison_ID,Person_ID and Price. The third: Person_ID and Persons_Number.
Now when i enter in form Arrival and Departure and Persons_Number after
update i need a function that calculates how many days are in which
saisons(when there are more) and multiplies them with Price regarding to
selected number of persons. The sum (of days by saison and prices) must be
appended to new table that has Guest_ID, Sum_Days, Sum_Price fields. Or is
it better to append it on the same table with arrival, departure and
persons_number?
Any help is apriciated
Many many thanks in advance
JJ
i have tables: Saison_TBL and Price_TBL, Person_TBL. The first one has 3
fields: Saison_ID, Saison_Start and Saison_End. The second: Price_ID,
Saison_ID,Person_ID and Price. The third: Person_ID and Persons_Number.
Now when i enter in form Arrival and Departure and Persons_Number after
update i need a function that calculates how many days are in which
saisons(when there are more) and multiplies them with Price regarding to
selected number of persons. The sum (of days by saison and prices) must be
appended to new table that has Guest_ID, Sum_Days, Sum_Price fields. Or is
it better to append it on the same table with arrival, departure and
persons_number?
Any help is apriciated
Many many thanks in advance
JJ