Hi I'm writing a cinema booking system and I want to search a films
database that contains all the film information including the starting
and ending dates - what I want is for the user to be able to search for
films starting date and have the films organized by date and I'd like
some kind of a function that would get the date from the system and
display films showing that day - I probably won't be able to do this
with a simple query of the date fields as say a films starts on the 1st
July and runs to the 18th I'd like that film to come up on all days ie
1st 2nd 3rd ...... 17th 18th so how do I

Investigate the Between...And Operator in your database engine's help files.
It's typically supported and usually appears as such:

SELECT * FROM tblMovies WHERE mov_start BETWEEN #07/01/1999# AND #07/18/99#;

This should return all movies that start within that time period, and, of
course, you could add extra "WHERE" constraints if needed.

-Curtis Spendlove
-Solstice Software