Results 1 to 4 of 4
  1. #1
    EdwinLawrence is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    2

    Counting in Query

    Hello, I have 2 tables. The 1st has dates in sequential order. The 2nd has a list of items (many) with a start date and "# of days" until an end date. I want to create a query, that for each date in the 1st table, it counts, or sums, how many events are open between the start date and (start date + "# of days" until end date). Ideas? Thanks!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,616
    What do you want to do with this 'count'.

    The easy way to dynamically number records is to build a report and have a textbox with RunningSum property set to Yes, ControlSource: =1
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    EdwinLawrence is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    2
    I want ot count for any given day how many events are "active". I then need to chart that result. So event A is from Jan 1 to Feb 1 and event B is from Jan 15 to Feb 15, so on so forth. So from Jan 1 to Jan 14 there is one event and from Jan 15 to Jan 31 there are 2 events ...

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,616
    Need to work with data if you want to provide the project.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Counting records of a parameter query
    By JonathanT in forum Reports
    Replies: 5
    Last Post: 10-31-2011, 04:33 AM
  2. Counting multiple items in a query
    By slaterino in forum Access
    Replies: 2
    Last Post: 10-14-2010, 08:21 AM
  3. Stumped! Counting query based on 2 different tables
    By TheWolfster in forum Queries
    Replies: 7
    Last Post: 09-10-2010, 01:10 PM
  4. Help with counting Query
    By metalhead22 in forum Queries
    Replies: 8
    Last Post: 04-29-2009, 02:07 AM
  5. Counting returned records in a query
    By johncob in forum Queries
    Replies: 0
    Last Post: 02-11-2009, 05:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums