Results 1 to 2 of 2

Thread: Access dilema

  1. #1
    Join Date
    Mar 2003
    Posts
    1

    Unanswered: Access dilema

    Guys I have four tables in an access database
    1 tblRoomType
    roomTypeID (PIK)
    roomTypeDesc (text)

    2 tblRoomSize
    roomSizeID (PIK)
    roomSizeDesc (text)

    3 tblHolidayPeriod
    holidayPeriodID (PIK)
    startDate (date/time)
    endDate (date/time)
    holidayPeriodDesc (text)

    4 tblRates
    rateID (PIK)
    roomTypeID (number)
    roomSizeID (number)
    holidayPeriodID (number)
    rate (currency)

    I have a form in which user can select room size, start and and end date and I have to give the user prices for three different types of room for that room size for that period. I cann't get this into my head. Can anyone help?
    TIA


    Sharjeel

  2. #2
    Join Date
    Sep 2002
    Location
    Land of OZ
    Posts
    173

    Re: Access dilema

    Originally posted by php95saj
    Guys I have four tables in an access database
    1 tblRoomType
    roomTypeID (PIK)
    roomTypeDesc (text)

    2 tblRoomSize
    roomSizeID (PIK)
    roomSizeDesc (text)

    3 tblHolidayPeriod
    holidayPeriodID (PIK)
    startDate (date/time)
    endDate (date/time)
    holidayPeriodDesc (text)

    4 tblRates
    rateID (PIK)
    roomTypeID (number)
    roomSizeID (number)
    holidayPeriodID (number)
    rate (currency)

    I have a form in which user can select room size, start and and end date and I have to give the user prices for three different types of room for that room size for that period. I cann't get this into my head. Can anyone help?
    TIA


    Sharjeel
    Building a dummy form up, will get back to you soon if you still require assistance.
    Mona
    ________________________________
    Life is too short to be sane or sensible. Weird people rule and normal people suck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •