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 wOOdy-Soft 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: *

  • Users: MASTERMIKE
  • Content: Threads
  • Order by date
  1. MASTERMIKE

    Using JOIN function to display discrete date values from a parameter

    How do I display discrete date values selected from a date parameter? I can easily display the first (minimum) and last (maximum) dates in a range, but what if I want only certain discrete dates that a user has selected, such as 8/14/03, 8/19/03, 8/27/03, etc.?
  2. MASTERMIKE

    Switch Function - Maximum Number of Arguments

    What is the maximum number of arguments I can use with a switch function in Crystal 8.0? I tried to create a very long formula using switch (using Crystal to write the code for me...I'm not completely insane...just a little) and got the error message "Too many arguments have been given to...
  3. MASTERMIKE

    Calulating averages when some records are duplicate and some distinct

    I am trying to calculate averages on fields where some records list as duplicates and others list as distinct. Using an average function yields an incorrect result since the multiple records are counted more than once. For example: Category A 7.40 Category B 10.00 10.00...
  4. MASTERMIKE

    Show only the first transaction date for each customer

    I am doing a report listing transaction dates for each customer. I want to show only the first transaction date for each customer, and if possible (but not required), group by first transaction date, so that I have a list of customers with a first trasaction date of 01/01/2002, a list with a...

Part and Inventory Search

Back
Top