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 biv343 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. lat4n6

    Nth most freq

    I WAS trying to add it as a formula in the selection criteria and was getting the error at the * when I tried to save it. {LABEXAM.Section} = "CRIM" and trim({LABEXAM.Report Format}) = "NONBIO" and {@backlog} > 30.00 and * if NthMostFrequent (1, {ITEMTYPE.Description}) = ["Clothing", "Other -...
  2. lat4n6

    Nth most freq

    Still getting: "The result of the selection must be boolean." other suggestions? thanks
  3. lat4n6

    Nth most freq

    *Fairly new user* How do I get the second most frequent if I don't want the first most frequent in certain instances?? I thought I could add this in the select expert, if NthMostFrequent (1, {ITEMTYPE.Description}) = ["Clothing", "Other - Evidence"] then NthMostFrequent (2...

Part and Inventory Search

Back
Top