Results 1 to 6 of 6
  1. #1
    Swarm & Punish
    Points: 282,995, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 45.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    keepngoal's Avatar
    Join Date
    Jun 2006
    Posts
    19,418
    Points
    282,995
    Level
    100
    Thumbs Up
    Received: 234
    Given: 492

    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.


    The first and best victory is to conquer self; to be conquered by self is of all things most shameful and vile. - Plato

    May you only need 39 acres to turn your rig around. - keep

  2. #2
    All-Star
    Points: 23,197, Level: 46
    Level completed: 65%, Points required for next Level: 353
    Overall activity: 1.0%
    Achievements:
    SocialVeteran10000 Experience Points
    cloneluke80's Avatar
    Join Date
    Apr 2006
    Location
    West Des Moines, IA
    Posts
    1,611
    Points
    23,197
    Level
    46
    Thumbs Up
    Received: 5
    Given: 2

    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
    Swarm & Punish
    Points: 282,995, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 45.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    keepngoal's Avatar
    Join Date
    Jun 2006
    Posts
    19,418
    Points
    282,995
    Level
    100
    Thumbs Up
    Received: 234
    Given: 492

    Re: Access 2007 Query Help

    Thanks!

    -keep


    The first and best victory is to conquer self; to be conquered by self is of all things most shameful and vile. - Plato

    May you only need 39 acres to turn your rig around. - keep

  4. #4
    Swarm & Punish
    Points: 282,995, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 45.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    keepngoal's Avatar
    Join Date
    Jun 2006
    Posts
    19,418
    Points
    282,995
    Level
    100
    Thumbs Up
    Received: 234
    Given: 492

    Re: Access 2007 Query Help

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

    Say; In or Out = 1234567891


    The first and best victory is to conquer self; to be conquered by self is of all things most shameful and vile. - Plato

    May you only need 39 acres to turn your rig around. - keep

  5. #5
    All-Star
    Points: 23,197, Level: 46
    Level completed: 65%, Points required for next Level: 353
    Overall activity: 1.0%
    Achievements:
    SocialVeteran10000 Experience Points
    cloneluke80's Avatar
    Join Date
    Apr 2006
    Location
    West Des Moines, IA
    Posts
    1,611
    Points
    23,197
    Level
    46
    Thumbs Up
    Received: 5
    Given: 2

    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: 23,197, Level: 46
    Level completed: 65%, Points required for next Level: 353
    Overall activity: 1.0%
    Achievements:
    SocialVeteran10000 Experience Points
    cloneluke80's Avatar
    Join Date
    Apr 2006
    Location
    West Des Moines, IA
    Posts
    1,611
    Points
    23,197
    Level
    46
    Thumbs Up
    Received: 5
    Given: 2

    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
  •  
  • Football
  • Iowa State vs. North Dakota State
  • August 30, 2014
  • 11:00 AM