Ms Access - Valid Query?? -

[emmim44]

Hi all,
Select Id from schedule where #06/23/08 10:30 PM# between sch_date + ' ' +sch_time_start And sch_date + ' ' + sch_time_end;

Is above a valid statement ? if Not how would I fixed it. sch_date and sch_time_start are dateformat in ms access.

[CreganTur]

Since you reference Access, I'm guessing that's the program you're working in.

I would suggest that you try building this query in the query design view. Once you get it working, then you can look at it in SQL view, which will allow you to see how this query should be properly formatted.