Discounts and More guests

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

Hi Guys,

I am trying to put a value to a type of guests in a
database. It goes like this:

If 4 guests stay in one room for seven days, it is going
to be $300.00 for the four of them, but if they add a next
person to the four (which will be five), it is going to be
$20.00 extra ($320.00 total), and if they add two more
persons, itis going to be $40.00 extra ($340.00 total). U
get the drift?

Also, I was wondering if guests stay in a room in 6 days,
it is $300.00, but if they stay more than 6 days, they
will get a 15 % discount. ANy ideas?

Is there somehow that I can do this? Query or in a table?

This is for some class work that I want it for. Our
teacher sucks. He expects us to know so much already!
AHHH!!

Peace.
 
I would store the number of guests and length of stay in the table and do all your calculations in queries

In the query, I'd include fields for BaseBill and ActualBill. I think something like this should work for you

BaseBill: IIf(([NoOfGuests])<7,300,(300+(20*(([NoOfGuests])-6)))
ActualBill: IIf(([DaysStaying])<7,([BaseBill]),(([BaseBill])*.85)

Hope this helps

Howard Brod


----- Daniel wrote: ----

Hi Guys

I am trying to put a value to a type of guests in a
database. It goes like this

If 4 guests stay in one room for seven days, it is going
to be $300.00 for the four of them, but if they add a next
person to the four (which will be five), it is going to be
$20.00 extra ($320.00 total), and if they add two more
persons, itis going to be $40.00 extra ($340.00 total). U
get the drift

Also, I was wondering if guests stay in a room in 6 days,
it is $300.00, but if they stay more than 6 days, they
will get a 15 % discount. ANy ideas

Is there somehow that I can do this? Query or in a table

This is for some class work that I want it for. Our
teacher sucks. He expects us to know so much already!
AHHH!

Peace
 
Back
Top