Results 1 to 4 of 4
  1. #1
    omegads is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    17

    Count times a word appears in a month

    Good day,

    Today i come with another question, my manager needs to know how many times we did tech support on a month. so this is my database; i'm using a table called incidents on which i have 6 Fields, ID(default access field), Working_On, Date_Started, Time_Started, Date_Finished,Time_Finished.

    what i have accomplished until now is to use a query to do a count function, returning me a query table with the different incidents on the Working_On field and on a second column the total of times that incident appears... what i really want to know if there's a way for my query to return the times an incident appears but by month....

    For example:

    Name of incident | Count January | Count February | Count March | :::::::::::::: | Count December|

    i've attached the file so you can see what i mean


    Count_by_date.accdb

    Best regards to all

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    use a crosstab query

    copy and paste this code into a new query sql window

    Code:
    TRANSFORM Count(Incidences.ID) AS CountOfID
    SELECT Incidences.Working_ON
    FROM Incidences
    GROUP BY Incidences.Working_ON
    PIVOT Month([Date_Started]);
    then go back to the query design window so you can see what it looks like

  3. #3
    omegads is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    17
    Hi again Ajax,

    maybe i should ask you directly instead of posting hahaha, you know my background now..... how do i create a crosstab query.... again, this is new... is still regarding the other database... just that my manager wants this module added

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    how do i create a crosstab query
    read my post properly

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

Similar Threads

  1. Replies: 4
    Last Post: 10-15-2014, 05:51 AM
  2. Replies: 3
    Last Post: 06-10-2014, 11:50 AM
  3. Replies: 14
    Last Post: 02-23-2012, 06:32 PM
  4. Count How Many times a value appears in a table
    By younggunnaz69 in forum Queries
    Replies: 1
    Last Post: 10-19-2011, 10:29 PM
  5. report the # of times a name appears in a field
    By rankhornjp in forum Reports
    Replies: 25
    Last Post: 08-04-2011, 01:45 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