Results 1 to 1 of 1

Thread: Report sum

  1. #1
    Join Date
    Sep 2002

    Unanswered: Report sum

    I have designed a workers productivity report using Acc 2K which is based on a query and the query is based on one table (all the fields I need Workers, EligDays...etc. are in the same table.
    Each worker has 10 business days to process the application. The way it's determine is I have a field called EligDays, which is a result of a calculation field. For example, let's say for worker name Tammy EligDay = 9 then Tammy process the application within 10 business days (<=10) and Tammy process two more applications over and EligDays = 11 & EligDays = 12 then Tammy process two applications over 10 business days (>10).
    1. I want the report to show Tammy <=10 = 1
    Tammy >10 = 2
    Total For Tammy = 3
    2. How can I force the report to show both <= 10 and >10 for each worker, even if there is no data..
    I have a sample report in Excel/word format, which will show you how the report should look like.

    Thank you in advance,

    Attached Files Attached Files

Posting Permissions

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