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

Search results for query: *

  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