Help with a project in ICT!

  Fateful Shadow 19:52 26 Sep 2003
Locked

I'm in the middle of doing a piece of coursework for my ICT GCSE and it involves using Access. I am designing and implementing a datbase that stores customer information and room information in a hotel.

My problem is that I need to do something that sounds quite complecated (well, to me it does!).

During the data collection of a customers details, I will collect the dates which they will stay from and to, and the room number. Say for instance, room 2 was booked for 23rd to the 25th of September, and someone wanted it for the 24th. How would I get the database to tell me that room 2 was already booked?

Do I have to build some sort of complecated expression?

Any help greatly appreciated!

Thanks :)

  VoG II 20:18 26 Sep 2003

If you don't get an answer here try click here but do not mention that it is a skool project - they're funny that way.

  graham√ 21:34 26 Sep 2003

complecated = complicated

  xania 22:46 26 Sep 2003

VOG

That's a useful link - I think I'll pop it into my favorites!

  Fateful Shadow 19:23 27 Sep 2003

I've just posted on their Access forum. VoG, thanks for the link...very helpful. Graham√, stop being so picky :)

  Fateful Shadow 13:41 28 Sep 2003

Thanks for that. I've got it sorted now....hopefully!

They replied to me in 2 days.......and with the look of the responce, it looks like it took them 2 days to write it!

Thanks again :)

  Sir Radfordin 14:42 28 Sep 2003

click here if you want to see that answer ;)

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017