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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sum Derived Field for Selection criteria

Status
Not open for further replies.

Brazelis

Technical User
Apr 7, 2004
1
US
I need to use a sum of a derived field to exclude records through selection criteria. I've created a derived field to give me a counter for each college course taken, I need to create a 2nd derived field to get me a total or sum of the college courses taken. Then I need to use the summed derived field in a selection criteria. I'm having problems getting the 2nd derived field to get me a total or sum, all I'm getting is the counter of 1.
 
It actually sounds like you might be able to do this without a macro.....give me a little more info about the data you're hitting.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top