Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    6

    Question Unanswered: Report features question...

    I am building a report that prints a pages for records of a single person (ie, each page only contains records for one person). Records consist of a location column with only 3 possible values. I would like my page footer to display a total of a numeric colum based on the location value. How can i keep a count of the records for each page/person?


    The page looks like this:

    Name - SSN
    -------------------------------------
    job#...hours.....location
    -------------------------------------
    135......22........A
    130......14........A
    335.......6.........B
    -------------------------------------

    The bottom should look like this

    Total Hrs Location A: 36
    Total Hrs Location B: 6
    Total Hrs Location C: 0

    Thanks in advance for any help!

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Make 3 textboxes in your report/page footer titled appropriately and put this code in the RowSource:

    =Sum(IIf([Location]="A",[Hours],0))


    and do the same for the other locations just changing the location value ...

  3. #3
    Join Date
    Nov 2003
    Posts
    6
    Originally posted by M Owen
    Make 3 textboxes in your report/page footer titled appropriately and put this code in the RowSource:

    =Sum(IIf([Location]="A",[Hours],0))


    and do the same for the other locations just changing the location value ...
    Thanks so much for helping. It seems that its not working correctly though. The report generates #error in place of the expected result. Any ideas?

    How does the IIF(x, y, z) function work???

    thanks again.

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    Originally posted by jvargas
    Thanks so much for helping. It seems that its not working correctly though. The report generates #error in place of the expected result. Any ideas?

    How does the IIF(x, y, z) function work???

    thanks again.
    myValue=IIF(Question, X, Y) means

    if the question is TRUE then my value = X
    if the question is FALSE then my value = Y



Posting Permissions

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