Search results

the problem i'm having is not on the main form its the calculation on the subform in the total property cost field.

1. the main form is booking this is going to pick up on the total property cost from the footer in the booking order subform. 2. subform is called booking order subform this issue is total property cost not calculating in the footer of this form. (not sure what u mean by subform container) 3...

hi i am using single form view and have all ready got the sum calculation in the form footer refering to the field on the main form but the calculation is not working

On my booking order subform (subform of booking form linked by booking no) i have booking no, property no, price per day, no of days, total cost and total property cost. All my fields are numeric and the total coat and total property cost are situated in the subfooter of the form and grouping is...

Hi In answer to your questions all the fields price per day, no of days and total cost are all specified as numeric fields and grouping is by property no but my total cost and total property cost are all in the details section on the booking order subform. do i need to move them to the footer...

Hi Bob I've tried that as well but it still shows 0

On my booking order subform (subform of booking form linked by booking no) i have booking no, property no, price per day, no of days, total cost and total property cost. total cost shows the price for that property no depending on amount of days total cost is worked out: =[price per day]*[no of...

Got it working Cheers for your help

Hi Ray creating a list is probably not the best way to do it because the start date is for a booking and user could creating a booking a few years in advance to have a list of every single saturday up to 2 years in advance seems a bit extreme. Is there no way of just validation the date being a...

Hi I have a start date on a form. The fields data type is short date I need to create a validation rule so that when a user enters a date it can only be a saturday date which is entered. Thanks for your help

I have created a query that will pull the price of a property into the cost field combo box on a booking order subform depending on the values of the start date and property number enter onto the same form. The query gets the price from the property price table matching on the property no i've...

Hi Paul Yeah the booking order form is a subform for a booking form which is not need for this query so i didn't forgot to mention that the booking order was a subform. The query itself fails to show any value.

Hi i am having problem creating a query that will pull the price of a property into the price field on to a booking order form depending on the values of the start date and property number enter onto the same form. i have a two tables property price and booking order. Fields in the property...

Thanks Dennisk Are you able to explain this is more detail as my programming skill aren't that great or do you know of any example of this type of problem

Hi I have created a database to take bookings for holiday properties but can't figure out how to stop the properties from being booked over the same period. I have a table called booking order with the fields Booking no, property no, start date and end date. On the equivilant form for a...