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 Rhinorhino 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 Magj

  1. Magj

    How to sort by alpha, then numeric value by a formula!

    I have the following data in my report ST0000663-10 ST0000663-11 ST0000663-1 ST0000663-2 ST0000663-3 SU0000663-10 SU0000663-11 SU0000663-1 How do I create a formula to sort the above data by the first alpha characters, then the number after the dash like below: ST0000663-1 ST0000663-2...
  2. Magj

    How to add an AD user without adding an AD group

    I'm trying to add an AD user to BOEXI, but I got the following error: "There was an error while writing data back to the server: Creation of the user hallc cannot complete because the user is not a member in any of the mapped groups." I can only add an AD usere if the users belong to a group...
  3. Magj

    How to pull data with a date range base on a parameter

    Thanks in Advance : ) All report run in the same year as last modify date. Thanks again.
  4. Magj

    How to pull data with a date range base on a parameter

    To whom it may concern, I have a report that user enter a parameter as follow: Available Parameter: 1ST Quarter 2ND Quarter 3RD Quarter 4TH Quarter I want to be able to pull data base on the above parameter with a database fields that have the last modify date: for example: If user enter 1ST...
  5. Magj

    How to remove character from a string fields

    I have a report that group by project name like the following "31000 - Everett-to-Seattle Track and Signal Improvements" How do I create a forumula to extract the above to just "Everett-to-Seattle Track and Signal Improvements" The next project might have a different number, but the all...

Part and Inventory Search

Back
Top