2 Replies Latest reply on Nov 26, 2012 1:40 PM by DavidJondreau

    If statement help

    ajayz

      I have a database of contractors working for our company and i have a field called "AGE" which is a calculated field that calcuales their current age based on their birthdate.

       

      I have created a sub summary report which I used to graph the total contractors by their age which works ok, however i would like to group the ages in the following groups to reduce the number of bars in the graph.

       

      ie 10 to 19

      20 to 29

      30 to 39

      40 to 49 etc up to 69

       

      I thought the best option would be to create a new calculated field using a "if statement" that checks the "AGE" in the fields and then enters the text value ie "20 to 29" in the calculated field. This means I will be able to create a new sub summary report and graph the data.

       

      I just got lost trying to write it..

       

      Is this a good solution or should I be looking at somehting else?

       

      Thanks for your help.