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 IamaSherpa 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. KatieO

    Columnar report

    This is the formula that puts the Activites into the Column e.g. January. The Product Codes denote the type of contact, like Phone Call, Email, Meeting IF Year({Activity.EFFECTIVE_DATE}) = 2002 and Month({Activity.EFFECTIVE_DATE}) = 1 then ToText({Activity.EFFECTIVE_DATE})+&quot...
  2. KatieO

    Columnar report

    Rows are Individuals, Columns are Months of the year. In the database, users create text entries like Phone call 4/02, Letter 4/15, Meeting 5/3. I can get the entries in the proper columns, but each text entry creates a new detail line. I want to group or summarize the entries so that one...
  3. KatieO

    Random records

    I have create a record selection formula that returns 2500 records. I am creating a list that I'm going to sell - the buyer only wants 2000 records. How do I get a random selection from the 2500?
  4. KatieO

    Simple Date Calculation

    I have a date field called "Expiration date." I want to add a selection criteria that would select all those with an Expiration date greater than or equal to 90 days prior to the Current Date. Thanks!

Part and Inventory Search

Back
Top