none
DAO recordset access 2010 RRS feed

  • Question

  • Hi need some help creating code for a database for a timetable system

    using recordset between two tables tblBooking and tblPriceBands

    price bands are 1/01/12- 1/04/12 adult cost £23 child cost £15 equipment cost £10 material cost £6

    02/04/12-01/07/12 adult cost £33 child cost £25 equipment cost £15 material cost £10

    02/07/12- 31/12/12 adult cost £19 child cost £10 equipment cost £8 material cost £4

    the above is in the tblPriceBands table

    I would like to use a booking form to enter number of adults / children and dates and for a button to calculate the total cost

    Sunday, October 7, 2012 6:21 PM

All replies