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!

Register Log in
  • 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!

Search results for query: *

  1. Tracy Leggett

    Nth Largest item based on Price but need to show Item #

    I need to show the ITEM.CODE that has the 2nd largest UNIT.PRICE. I have entered a summary field for the UNIT.PRICE with Nth Largest, N is 2 and it returns the UNIT.PRICE. Rather that show the price, I need it to show the ITEM.CODE. I had tried a formula of …………… if {UnitPrice} = NthLargest...

Part and Inventory Search

Back
Top