Results 1 to 6 of 6
  1. #1
    Jobless Jerk
    Points: 332,422, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 24.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    keepngoal's Avatar
    Join Date
    Jun 2006
    Posts
    22,631
    Points
    332,422
    Level
    100
    Thumbs Up
    Received: 2,351
    Given: 5,515

    Access 2007 Query Help

    My table has these fields:

    ID
    Date
    Time
    In
    Out

    I need to count the number of In and Outs by date that is between certain times.

    I have the criteria for the times question: between #17:00# AND #21:00#.

    how do i set up the query to count the number of In and Outs for a day (data is daily from Jan 1, 2011 to present) with the Time requirement?

    Thanks in Advance,

    -keep.


    This post is pending approval of site sponsors.

  2. #2
    All-Star
    Points: 26,213, Level: 49
    Level completed: 67%, Points required for next Level: 337
    Overall activity: 3.0%
    Achievements:
    SocialVeteran25000 Experience Points
    cloneluke80's Avatar
    Join Date
    Apr 2006
    Location
    West Des Moines, IA
    Posts
    1,740
    Points
    26,213
    Level
    49
    Thumbs Up
    Received: 39
    Given: 129

    Re: Access 2007 Query Help

    Select DATE, COUNT(IN), COUNT(OUT) FROM TABLE
    WHERE TIME BETWEEN #17:00# AND #21:00#
    GROUP BY DATE

    This is pseudo code, but should do the trick.



  3. #3
    Jobless Jerk
    Points: 332,422, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 24.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    keepngoal's Avatar
    Join Date
    Jun 2006
    Posts
    22,631
    Points
    332,422
    Level
    100
    Thumbs Up
    Received: 2,351
    Given: 5,515

    Re: Access 2007 Query Help

    Thanks!

    -keep


    This post is pending approval of site sponsors.

  4. #4
    Jobless Jerk
    Points: 332,422, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 24.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    keepngoal's Avatar
    Join Date
    Jun 2006
    Posts
    22,631
    Points
    332,422
    Level
    100
    Thumbs Up
    Received: 2,351
    Given: 5,515

    Re: Access 2007 Query Help

    Now if I want to add a qualifier to the In and the Out?

    Say; In or Out = 1234567891


    This post is pending approval of site sponsors.

  5. #5
    All-Star
    Points: 26,213, Level: 49
    Level completed: 67%, Points required for next Level: 337
    Overall activity: 3.0%
    Achievements:
    SocialVeteran25000 Experience Points
    cloneluke80's Avatar
    Join Date
    Apr 2006
    Location
    West Des Moines, IA
    Posts
    1,740
    Points
    26,213
    Level
    49
    Thumbs Up
    Received: 39
    Given: 129

    Re: Access 2007 Query Help

    Select DATE, COUNT(IN), COUNT(OUT) FROM TABLE
    WHERE TIME BETWEEN #17:00# AND #21:00#
    AND Out = 1234567891
    GROUP BY DATE



  6. #6
    All-Star
    Points: 26,213, Level: 49
    Level completed: 67%, Points required for next Level: 337
    Overall activity: 3.0%
    Achievements:
    SocialVeteran25000 Experience Points
    cloneluke80's Avatar
    Join Date
    Apr 2006
    Location
    West Des Moines, IA
    Posts
    1,740
    Points
    26,213
    Level
    49
    Thumbs Up
    Received: 39
    Given: 129

    Re: Access 2007 Query Help

    i feel like I should be charging you :)



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
  • TV: TBA
  • Football Season Opener vs. UNI
  • September 3, 2016
  • 07:00 PM