Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Interval Grouping (Access 2000)

    Greetings all: I have a vehicle accident database and am trying to determine how many accidents have occurred by each age group, e.g. Age 1 = 400 accidents, age 2 - 350, age 3 = 450, age 4 = 250. This part I have calculated with a totals query using age as group by and (count) report number. What I would like to accomplish is a report with the grouping as such: Group 1 = ages 1 to 4 = 1450, ages 5 - 9 = 1350, etc. Any and all help would be greatly appreciated. By the way, I have tried the grouping option on a report using interval and group interval of 4 but get undesirable results. TIA.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Interval Grouping (Access 2000)

    If your age groups have equal intervals, you can create a group level with a calculated expression in the report: in the Sorting and Grouping window, enter

    =[Age] 5

    where Age is the name of the age field. Just use the standard group interval of 1.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Interval Grouping (Access 2000)

    Hans: Thanks so much.

Posting Permissions

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