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

Recent content by pzippel7

  1. pzippel7

    headings in group header

    Group Header question... CR 8.5, Access db. I am grouping on a formula. The formula simply creates a group name (text) based on ranges of values calculated in another formula. The problem I have is that if there are no instances of data in the range of any of the group names, the group name...
  2. pzippel7

    Grouping on a formula

    Actually, I'm trying to sort it by the % over tolerance fielde (which doesn't show as an option in Top N). Maybe example data will help Group: ABC Corp Loan Count # Resolved >5 days % Over Tolerance 10 10 100% 5 2 40% 100...
  3. pzippel7

    Grouping on a formula

    CR 8.5 Access db Within a group, I have three data items; 1. A distinct count of loan numbers 2. Aging (# days) .... >5 is considered late //@count >5 if {@age group}in 0 to 5 then 1 else 0 where the "age group formula is: Abs ({Retail Closed File Table.OPENDATE}-{Retail Closed File...

Part and Inventory Search

Back
Top