Search results

So would that be a statement along the lines of IF Text28 = Booking time Then error message

One more quick question how do i make the concatonates field

Cheers the help is greatly appreciated mate

Standard one hour block

yea its is Booking ID, Booking Time, Booking Date, Facility ID, Facility Name, Facility Cost, Member ID, Member Name, Discount ID, Discount Amount and total cost

yea its done through a form and the information is stored in a table

i want to stop the user from being able to book somebody using the same facility on the same day and time but i am not sure how to go about doing this. would it be a query, or could i apply a macro to check this?

Cheers that is greatly appreciated. I have another issue now. I want to be able to make bookings but i want to stop double bookings so someone can't book something for 7am if it has already been booked any suggestions?

Thanks my mind went completely blank and was making it more complicated. Your help is very much appreciated

Hello, I was wondering if someone could give help on this, I have a table called booking that has Booking ID, Time, Date, Cost, Member ID, Facility ID, Discount ID and Overall cost. My overall cost however is Dependant on the Amount discounted off the original cost. However once i have this...