Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Posts
    10

    Red face Unanswered: Please help! Simple Report Question I think

    I have a table with the following feilds:

    accident code
    Area
    Location
    Total

    I need to generate a report telling me the number of accidents and total per location and the number of accidents and total per area. The total is a calculated number feild and for some reason does not show up......can someone please help me with this. What exactly i need is the total costs of all accidents, not indivual accidents. Please help I am desperate

  2. #2
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    Does the report have multipe Locations? if So just click Sorting and Grouping and put your location field in the field box. Then turn on the footer for that sort. In that footer use the Sum() command

    [edit]
    Sum will do the adding for the cost Count() will do how many.
    So make two textboxes one with
    Code:
    =Sum([Total])
    and the other
    Code:
    =Count([location])
    That should work...Is an area like NorthWest Region and a location is a town in that area?
    Last edited by rguy84; 08-17-04 at 14:49.
    Ryan
    My Blog

  3. #3
    Join Date
    Aug 2004
    Posts
    10

    Talking Thank you

    Thank you I will try that now.....

  4. #4
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    Yes, no problem
    Ryan
    My Blog

Posting Permissions

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