Re: how to match time ranges for multiple records in a query?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Bob,

I am trying to get this code to work but I get a different result. I
am using Access 2000. Here's what I get when I put the final SQL in a
query and run it:

userID day timeStart timeEnd
1 MON 12:00:00 PM 1:00:00 PM
2 MON 12:30:00 PM 1:30:00 PM
2 TUE 12:00:00 PM 2:00:00 PM
3 TUE 12:15:00 PM 1:00:00 PM
2 WED 1:00:00 PM 10:00:00 PM
1 WED 3:00:00 PM 6:30:00 PM
5 WED 4:00:00 PM 8:00:00 PM
4 WED 5:00:00 PM 7:00:00 PM


I suspect it is because I am using Access 2000 and not SQL server like
you. Do you know what changes I need to make to your code to get it to
run properly in Access 2000?

Thanks,
Mike

.

Relevant Pages

  • Re: Search Numbers at Lists
    ... Oh I have forgotten the Full-Text-Search. ... >I suspect that if you check out how SQL Server Full-text search works, ... > Mike Walsh, Helsinki, Finland ...
    (microsoft.public.sharepoint.windowsservices)
  • Problem creating a new task
    ... I am using Project 2000 and have a project stored in a SQL Server ... database. ... Prev by Date: ...
    (microsoft.public.project)
  • Re: re-run snapshot agent for each new subscription?
    ... Mike, ... It'll return a row if there is a publication snapshot ... Paul Ibison SQL Server MVP, ... Prev by Date: ...
    (microsoft.public.sqlserver.replication)
  • Using Bind Params in MySQL
    ... I am using MySQL and this was working, but all of sudden it is not. ... suspect that I have some kind of error, but my error logic must not be ... Mike ... Prev by Date: ...
    (comp.lang.perl.misc)
  • MySQL - Using Bind Params, Error Logic
    ... I am using MySQL and this was working, but all of sudden it is not. ... suspect that I have some kind of error, but my error logic must not be ... MIke ... Prev by Date: ...
    (perl.dbi.users)