Hi
I have created a database to record the room hire at our centre.
I have an input form based on a query using only the booking table, where the user enters the details of the booking, dates times number of bookings etc and calculated fields work out the sub total, discount, Vat net total, vat and amount due.
It then produces a booking form based on a query using several tables including the booking table and the calculations for sub total, discount, Vat net total, vat and amount due are made again.
My initial problem is that the report is rounding the amount due up and the form is not.
My second question is am I doing these calculations in the correct places and should the results be stored in the bookings table?
I have tried to do the calculations directly in the table but the datediff was not allowed and the discount % is not stored at that level it is stored on the Client table as it depends on who the client is.
Thank you in advance for any advice you can offer.
I have created a database to record the room hire at our centre.
I have an input form based on a query using only the booking table, where the user enters the details of the booking, dates times number of bookings etc and calculated fields work out the sub total, discount, Vat net total, vat and amount due.
It then produces a booking form based on a query using several tables including the booking table and the calculations for sub total, discount, Vat net total, vat and amount due are made again.
My initial problem is that the report is rounding the amount due up and the form is not.
My second question is am I doing these calculations in the correct places and should the results be stored in the bookings table?
I have tried to do the calculations directly in the table but the datediff was not allowed and the discount % is not stored at that level it is stored on the Client table as it depends on who the client is.
Thank you in advance for any advice you can offer.