I have the following in the report:
Goal
Jan Achieved
Feb Achieved
Mar Not Achieved
Apr Achieved
I'm trying to add a footer to this report, displaying the number of 'Achieved'. I got the footer and textbox without problem, but what do I put in the 'Control Source' for the footer textbox that will count the number of 'Achieved' (in this case, 3)? I started with "=Count([goal])", which counts the total number (4), but I can't figure out how to make it so it'll only count the one with 'Achieved'. Any help?
Goal
Jan Achieved
Feb Achieved
Mar Not Achieved
Apr Achieved
I'm trying to add a footer to this report, displaying the number of 'Achieved'. I got the footer and textbox without problem, but what do I put in the 'Control Source' for the footer textbox that will count the number of 'Achieved' (in this case, 3)? I started with "=Count([goal])", which counts the total number (4), but I can't figure out how to make it so it'll only count the one with 'Achieved'. Any help?