Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2015
    Posts
    52

    Unanswered: Counting duplicated dates as one day in a date range

    I want to count in a query how many days are in a set of records, the date is repeated several times. I can only get it to count each record as a separate day and I want to count each day once. What expression do I use in a query?

    ID DaysServ

    1100740 12/1/2016
    1100830 12/1/2016
    0600900 12/2/2016
    1101000 12/2/2016
    1101030 12/2/2016
    0500630 12/3/2016
    1100800 12/3/2016
    0800840 12/4/2016
    0800940 12/4/2016
    0201100 12/5/2016
    0301130 12/5/2016
    0200700 12/5/2016
    0300730 12/6/2016
    0200800 12/7/2016
    0300830 12/7/2016

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    629
    Provided Answers: 32
    Make Q1 to pull the data from the table,set property UNIQUE VALUES = true.
    Only the dates.

    Then make Q2 that uses Q1 to do the count.

Posting Permissions

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