Hi Guys, I wonder could anyone help me? I have a college assignment for an access project. The database is about renting cars out to customers. I have build the tables up and how they link to each other (1 To M), the bit I could do with some help on is one the user requirement is to show a list of dates free for a certain date. So for example the user inputs [1/03/2009] till the [4/03/2009] and a list should appear allowing the user to see what is free and what is not. To do this would this be a query??, and using a long SQL command?? to select the tables? Also, when a user uses access form to input the data will the query stop people putting in a car that is allready being used by someone else? i.e to stop one car from being used by another customer in the same time frame. I could really do with some help / advice on how to do this! Each car has its own class brand (A to E) and, a hire table which shows the car reg number and the first day of hire and last day of hire. Also a car table which shows which user is using what car. Please Help! Cheers If you need picture of the ER model of the table let me no... might show you what I mean. I am quite new to access as well.