Search results

I've just started a computing course which involves making a database based on a linear specification. My tasks will involve a variety of things; from having two forms interact with eachother in order to produce results, and to simple formating. Can anyone give me any advice on where to start...

So far I have a query that picks up any collisions between booking dates with the following: SELECT [Customer Details].[CustomerID], [Booking].[RoomNumber], [Booking].[DateFrom], [Booking].[DateTo] FROM [Room Details] INNER JOIN ([Customer Details] INNER JOIN Booking ON [Customer...

I'm making a booking system and I've got most of it ironed out now except for one last thing. My start and end dates for the booking need to be made so when I click a button, say 'Check', it'll show me all the conflicting present bookings. Not sure the best way to go about this? I was thinking...

Well basically I have a form with a button on it and some fields. The button brings up another form with that related data of the current record already on display. (Did all this using wizard) How can I get it to show the related data but also have access to the rest of the data that isn't...