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 Mike Lewis 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. Margiola

    What is the CHR( ) function?

    Check out http://en.wikipedia.org/wiki/ASCII#ASCII_control_characters for a full list of ASCII control characters or http://en.wikipedia.org/wiki/ASCII#ASCII_printable_characters for a list of ASCII printable characters.
  2. Margiola

    Date Time Conversion

    To convert a string or number to a date or to a datetime, use the CDate or CDateTime function in a formula, eg CDate ("10/24/2006 06:00am") or CDateTime ("10/24/2006 06:00am")
  3. Margiola

    Record selection - Excluding rows w/ duplicate data in multiple fields

    Hi, create a FACILITY group and move this between the Booking ID and Res Type groups so it is the second group. Suppress GH2 and GF2.
  4. Margiola

    How to change the datasource location on many reports

    Thanks very much for your response. Re the advert, yes, this is the product we downloaded but cannot seem to make the necessary changes for sub-reports and haven't had any response from softwareforces to our enquiries. I'll check out Ken's website for other possible applications. Cheers for the...
  5. Margiola

    How to change the datasource location on many reports

    Hi, I use Crystal Reports v10 against a SQL server using ODBC. I have been banging my head against a brick wall for some time whenever I need to move reports from a test to production environment and change the datasource location. In 8.5 you could reset one table and propagate the changes...

Part and Inventory Search

Back
Top