Hi Friends

These days i m working on a s/w for cable operators . and i need to ask two Problems i m facing.........

Problem 1


In the Program i need to qry database with respect to time.....

Actually i m running a movie in media player displayed in form ...
Now i need to make it dynamic . Wat i mean to say is Program runs the movie , Song on the schedule .
Now when i qry the Access database for the movie between 08:30:00 Pm and 12:20:30 Am i get Two Results

1. i get all the records independent of time...
2. i get no Result..........

the Qry Does not seems to work.........

Here is the Qry ..........

Select * from table where MovTime is >= #"& startTime &"# and movietime <=#"& endtime &"#"




i have defined the field date/Time and in format long time....... in the database.........

Problem 2

i need to Add the time............

E.G i give movie the starting time... and i get the movie Total Time.... now i need to calculte the End Time ... How should i approach this...... one Solutio i have is

To convert hours and minutes into sec for starting time also the movie duration time........ and then add these seconds to obtain the max seconds and then return the hr and minutes back..........

at the same time i need to make sure that AM and PM are ok


Really in Tension

Plz do solve my Problem if u can ...........


Normal Vb Coder