Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2015

    Question Unanswered: count grouped dates on reports

    Hello all,

    I have a database which is fairly basic, a few tables and queries and one report.

    my query
    Combines SDate Number Qty Rate Extra
    Employee1 12/1/15 0001 .5 50 5
    Employee1 12/1/15 0002 .25 50 5
    Employee1 12/2/15 0003 1 50 5
    Employee1 12/2/15 0004 1 50 5
    Employee1 12/3/15 0005 .5 50 5

    I have ran a report to summarize like:
    Combined SDate Number Qty
    Employee1 12/1/15 0001 .5
    0002 .25
    12/2/15 0003 1
    0004 1
    12/3/15 0005 .5

    But would like to summary and add additional formulas in the footer
    Total Rate Extended
    Qty =sum([qty]) =[rate] =sum([qty])*[rate]
    Driver =count([Sdate]) =[extra] =count([SDate])*[extra]

    I cannot figure out how to get a count of the dates listed, every time i try something different i get the same result 5 when it should be 3.......
    this report at peak have 1800 numbers with 15 employees over a 3 month span, reports will be ran with a date filter(start & end) on open.

    thank you in advance for any help

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    ? not entirely certain what it is you are trying to achieve. it may be that you need to place some code behind the report that does your counting for you

    what are you wanting from COUNTing a date value.

    you may getaway with expressly converting the column to a number
    eg:- count(cdbl[SDate])

    alternatively you could do the summarisation as a sub report and embed that in the main report
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Dec 2015
    I need to count the number of summarized dates... currently it counts all 5 entries i need it to count that entries only happened on 3 of those days

  4. #4
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 18
    If you have a report, have you tried using the report grouping and header/footer capabilities?
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Tags for this Thread

Posting Permissions

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