Results 1 to 3 of 3
  1. #1
    DOC is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2013
    Posts
    5

    Query find records with zero activity in 60 days

    EDIT: Sorry wrong Title, Should be: Query Count number of days not total number of days.

    I am new to Access, and am having several problems I am have been spending several days trying to resolve. I will start with this one first.

    Table query is made: [ID], [CheckinDate], [Call] [QNI], [QTC] note: QNI / QTC are YES/NO)

    Query Results Example:
    [ID], [CheckinDate], [Call] [QNI], [QTC] [Sessions] <<<(Sessions in not the table, I created in query. >>> Sessions: (Day([CheckinDate])))
    [1], [11/04/2013], [AAAA] [-1] [0] [4]
    [2], [11/04/2013], [BBBB] [-1] [-1] [4]
    [3], [11/11/2013], [CCCC] [-1] [1] [11]
    [4], [11/11/2013], [DDDD] [-1] [0] [11]
    [5], [11/11/2013], [EEEE] [-1] [-1] [11]

    When I count(*) by Date, I get (5), I want an answer of (2)
    Can I get this results in query or do I have to do in report? How?
    Do I need the [Sessions] field?
    I want a query and Report to end with this result: QNI: 5, QTC: 3, SESSIONS: 2
    Thank you,

  2. #2
    DOC is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2013
    Posts
    5

    Query find zero activity in 60 Days

    Every Monday I attendance into my database. There will be approximately 50-65 records recorded weekly of the 90 people in "active" list with a total around 1500 recorded at month end.
    Objective: Query using two tables to find people who have had zero activity in 60 days. They will then be "unchecked" [NMPPN] to go "inactive".
    I need to use two Tables in a query. I don't know how to combine two tables and will need help with this. Also, I need help with the formula to find zero activity in 60 days.

    tblNetArchive and tblDataBase

    tblNetArchive tblDataBase

    [CheckinDate], [Call] [QNI], [QTC] [NMPN] << YES/NO (Using just one field from tbleDataBase)
    [9/16/2013], [AAAA] [0] [0] x
    [9/16/2013], [BBBB] [0] [0] x
    [9/16/2013], [CCCC] [0] [0] x
    [9/16/2013], [DDDD] [0] [0] x
    [9/16/2013], [EEEE] [0] [0] x

    QNI & QTC are YES/NO

    The above would be the last date of activity (60 days ago), I would then uncheck the [NMPN] making them inactive.
    Thank you

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,746

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

Similar Threads

  1. To find Month and Days in given date period
    By waqas in forum Programming
    Replies: 1
    Last Post: 02-12-2013, 02:50 PM
  2. Query Showing No Activity
    By tabbycat1234 in forum Queries
    Replies: 9
    Last Post: 12-06-2011, 06:09 AM
  3. Replies: 2
    Last Post: 10-08-2011, 06:33 PM
  4. No activity in last 30 days
    By CMLS in forum Queries
    Replies: 4
    Last Post: 03-18-2011, 11:26 AM
  5. Find Records Query
    By sullyman in forum Programming
    Replies: 1
    Last Post: 10-28-2009, 08:49 AM

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