Recent content by StuckInLiverpool

Are you saying that if a page can contain 30 lines, you have some departments with 32 records, so the last 2 lines go onto the next page?

I don't understand your question. You say: "My Report or Query or Table are not showing field values from calculated fields in FORM." Which is it that doesn't show field values? Your tables won't show any field values from calculated fields. Can you please rephrase your question?

Yes, in the header space, enter: =[reports]![name of thereport]![what you've written in the first parameter box, eg Start Date] Repeat for the end date, changing the last field above Hope that helps.

Thanks for your reply. I'm not too experienced with Access and don't know what you mean by multi field indexes without it being the primary key. You're right - I'd be much better off with an autonumber ID for the booking, but I don't know how to do that and still prevent them from booking the...

No, that was to prevent the double booking, so that if someone chose the same date and room twice, it would be rejected.

Thanks, RuralGuy. The actual double booking bit is sorted, it's the problem of trying to also charge for room service items.

Hope someone can help. I need to create (for college) a small database for a hotel. It must prevent double bookings. I have the following tables: Customer BookingStaff Rooms Bookings (with composite key: BookingDate and RoomID. It also has CustomerID as a foreign key.) This works well...