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 John Tel 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: tr0ubleduser
  • Order by date
  1. tr0ubleduser

    Return data in one row

    Thank you so much, you have made my life so much easier.
  2. tr0ubleduser

    Return data in one row

    Thanks! this works great. I have another question. There are certain complaints where the basis is repeated more than once. For example. CompID Basis Issues 1 Sex,Sex,Age Sexual Harrasement,Female,Accomodation Is there a way to display the basis only once if its being repeated...
  3. tr0ubleduser

    Return data in one row

    Hi all, I am using CR 10 with SQL Server 2000. I am trying to create a report which will display the complaints that are filed withing our complaint tracking system. I am not sure how to begin with this report. Here are the three main fields that should be in the report. 1. Complaint ID 2...
  4. tr0ubleduser

    Totals not working

    Thanks for the quick and accurate response.
  5. tr0ubleduser

    Totals not working

    Hi all, I am working with CR 10 and SQL server 2000. My report is based on a view. There are 6 columns which are currently in the details section. I have a written a formula to calculate the "Total" column. For some reason the column is not showing any values and is just balnk. The report...
  6. tr0ubleduser

    Adding 15 days to a Date

    Thank you both for the quick response. Damon, you were right about the '0'. I tried your formula and it works like a charm!
  7. tr0ubleduser

    Adding 15 days to a Date

    Hi all, CR 10, SQL Server 2000. I am trying to write a formula to add 15 days to a Datetime field. If the Datetime field is null then it should only return zero. I am not sure how to proceed with this. Any help will be appreciated. Thanks!

Part and Inventory Search

Back
Top