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 gkittelson 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. stalukder

    Cross Tab formatting question

    Hello, This may be a simple answer but is there a way to create a cross-tab that looks like the following... # of Accts # of Shirts $ of Revenue Rep1 10 15 $150.00 Rep2 5 10 $100.00 the # of accounts will have to be a...
  2. stalukder

    Sorting a "Sum of" formula in the Group Header

    hello, I am trying to rank our sales reps based on total sales in the group header. Right now I got the total sales for each rep in a SUM formula in the group header. Is there a way to sort the SUM of Sales field where the rep with the most sales comes up first. So for example. Group Header...
  3. stalukder

    Need to get the Second Character in a String Field

    Hello, I need to pull the second character out of a field. The Field is a string. My field can display the following... F9CC, F8CC, P8CC, F7CK, F6CC, P7CC, etc. I want to pull the second character (the #) so I can use that for a formula. What formula should I use to get the second...

Part and Inventory Search

Back
Top