Recent content by Chris_A1

The problem with that is that all bookings are shown which do not match the criteria. And what about if a room has no booking which matches the criteria. That room would not be shown on the list so therfore you would be unable to book it.

This seems to be a very common problem and one I am struggling with too. I have been working on a booking system for my company for a few months now and am able to show rooms that are booked for a certain time period but the problems come when I try and show rooms that aren't booked. As for...

Thanks very much for your help. Maybe I am trying to do much. I already have a field called ArtistSortName but I was hoping not to have to use it. The database contains 1425 different artists up to now! Another problem I have is: Track: Battleship Grey Artist: DJ Tiesto feat. Kirsty Hawkshaw...

would you suggesting adding another field saying what type of artist it is. e.g SoloArtist (like Michael Jackson) or Duet (like Paul Van Dyk featuring Saint Etienne) Group (like The Chemical Brothers) Do you think that would make it easier then to convert the name to a format which I could sort.

Hi I have a music database in which I want to convert [ArtistNames] into a format which will sort correctly. For example I need to convert: 1. Michael Jackson to Jackson Michael 2. Matt Schwartz presents Sholan to Schwartz Matt Scholan 3. Porn Kings Vs Flip & Fill feat. 740 Boyz to Porn Kings...

I've now replaced that query with: PARAMETERS AD DateTime, DD DateTime; SELECT Bookings.Caravan, Bookings.ArrivalDate FROM Caravans INNER JOIN Bookings ON Caravans.Pitch = Bookings.Caravan WHERE ((([AD])>=[ArrivalDate] And ([AD])<[DepartureDate]) AND (([DD])>[ArrivalDate] And...

I've created a query which will return room bookings that will clash with two given dates (the arrival date and departure date): PARAMETERS AD DateTime, DD DateTime; SELECT Bookings.Caravan, Bookings.[Arrival Date], Bookings.[Departure Date], Bookings.Customer FROM Bookings WHERE...

Wouldn't it best to use nights instead of days. i.e Nights: [DepartureDay]-[ArrivalDay] I've used that on my database and it works fine.

Yeah the search feature really is quite good. It seems like I've posted a fairly common problem and in future I'll use search before posting!

Yes, RoomReserved should be RoomID.

For my college project I am attempting to create a reservation system (in Access) which could be used in a hotel for booking rooms. I have so far created the following tables: Bookings: BookingID CustomerID ArrivalDate DepartureDate RoomReserved etc Customers: CustomerID Surname Address etc...

Right, thanks for your help. I'll try out your suggestions and post a reply with how I get on tomorrow. Thanks again. Chris

I'm trying to create a form for people to fill in for a fantasy football league. The eleven fields are the eleven players they have to choose from a list of first goalkeepers, then defenders, then midfielders, and then strikers. I then need the total field at the bottom of the form to tell...

I have created a form where the first three fields are the customer's details and the next eleven are the products they've chosen from a look up table. My problem is that I then want to make a "Total" field based on the total value of the products they've chosen. I've tried this formula...