Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Oct 2001
    Location
    Bristol, Bristol, United Kingdom
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    In the Midnight hour! (Access 2000)

    I use a report that links to our main database and picks up whether an incident occurs inside or outside of working hours, and the customers affected. I am able to replicate it to give an overall answer for both in and out, but the results differ slightly. I have investigated and am wondering if an incident raised at "00:00:00" (i.e. Midnight) somehow confuses Access?? My simple report lists the incidents and adds them up has 36 more customers than the other report that just gives the answer - there is an incident at "00:00:00" with 36 customers involved. There are no other incidents at midnight. Can anyone say whether this is a problem and give any suggestions???
    Thanks,
    Al.

  2. #2
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: In the Midnight hour! (Access 2000)

    A quick thought is that you have a criteria in there somewhere like >#09/09/2002# which would exclude midnight. try >=#09/09/2002#

    HTH

    Peter

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: In the Midnight hour! (Access 2000)

    Don't forget the and < #9/10/2002# part.
    Charlotte

  4. #4
    Lounger
    Join Date
    Oct 2001
    Location
    Bristol, Bristol, United Kingdom
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: In the Midnight hour! (Access 2000)

    Thanks - this has put me on the right track!! It's all written VB (ugh!) , but I've had a look and I think it may be to do with an end time being 23:59:59 and a start time 00:00:01.....therefore mising out 00:00:00!! I've had trouble with Excel and times / dates before, so thought it may be a "quirk" or the system, but this seems much simpler to fix! I've reported my findings, but will be back if this isn't the problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •