How do use record information in a sub form to calculate an unbounded record in the parent form
My subform pulls up the price for a room, category and rate which is specified in the main form.
I want to muliply this price with the No of hours the room is used for, which is in the main form.
Is there an alternative to multiple embedded if satements.
I would like to calculate a cost and update the table and form but it depends on the following information:
Room Booked: 3 options Room 1, Room 2 and Room3
Rate: Daily or Hourly
Category: 3 options: Member, discount or Full
I have a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.