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 TouchToneTommy 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: kkowalski
  • Content: Threads
  • Order by date
  1. kkowalski

    Multiple Excel Datasources-merging in Crystal

    I Need help desperately: Crystal Reports 9 on WinXP, using Excel worksheets at datasource. I have several excel worksheets imported as datasources and linked by a common ID field. Each spreadsheet contains a different subset of the larger spreadsheet. The main sheet contains an ID# and...
  2. kkowalski

    Displaying record for given date

    Thanks, synapsevampire for earlier response below. This did return a value, but not what I needed. I need to display the value in {CSL_STD_CALENDAR.STD_ACTIVE_ON_DAY} (which is Y or N) for the date (({CSL_STD_CALENDAR.CAL_DATE}=CDate (2004, 05, 01)) I cannot use select expert and just set the...
  3. kkowalski

    Convert date field to string value

    I am trying to use if..then to select dates with certain criteria... if ({CSL_STD_DEMO_SCHOOL.ENROLLMENT_DATE})<= Date (2003, 08, 20)then "2003, 08, 20" else if ({CSL_STD_DEMO_SCHOOL.ENROLLMENT_DATE})> Date (2003, 08, 20) then {CSL_STD_DEMO_SCHOOL.ENROLLMENT_DATE} The formula works for getting...
  4. kkowalski

    Multiple Text String query

    I have a text field, 255 char, free text input called {reasons}. I am trying to write a formula to query that field for multiple, possible text strings. For example, I will want to include all responses that include "fish", "culture" or "dance" What is the best way to have the report query that...

Part and Inventory Search

Back
Top