Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am trying to setup a query that will count the number of dates a person is absent and show the number and the person's name and Absence reason

    I have fields titled:

    AbsenceDate
    LNFN
    AbsenceReason

    I can't get it to work.

    Can someone help.

    Thanks.

    Paul

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Presumably, different absence dates may have different absence reasons.

    If you want a total count of absence dates per person, you can't display an absence reason with it because it won't be unique.
    - Create a query based on the table.
    - Add the LNFN and AbsenceDate fields to the query grid.
    - Select View | Totals.
    - Set the Total option for the AbsenceDate column to Count (the other one can remain as Group By).

    If you want a count for each reason:
    - Create a query based on the table.
    - Add the LNFN, AbsenceReason and AbsenceDate fields to the query grid.
    - Select View | Totals.
    - Set the Total option for the AbsenceDate column to Count (the other two can remain as Group By).

  3. #3
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Hans.

    Now I understand what I was doing wrong. It works fine now.

    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •