Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Expression builder on report

Status
Not open for further replies.

gundie

Programmer
Feb 5, 2004
69
US
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?
 
Nevermind, found solution in the forum! Next time I should read before I post. :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top