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 strongm 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. Gary Hnat

    Crystal Reports extracting data from partial fields entries in a database

    Although your solution appears to work on paper its a bit cumbersome .. and it's simply not feasible due to the fact that numerous users in numerous locations will be running this same Crystal report over the network ... that I am looking to have a single field appear as Seattle Denver Atlanta...
  2. Gary Hnat

    Crystal SQL Code linking to partial database field entries

    Sorry .. me bad!
  3. Gary Hnat

    Crystal Reports extracting data from partial fields entries in a database

    Thanks for the quick reply! The database is "Interbase/Embarcadero" (not MS SQL) All I can give you is SQL code from a similar type of report that utilizes the BOOKING and CITY tables I guess what I am looking for is a way in Crystal SQL to link up characters 1-3 from B.ITINERARY and take...
  4. Gary Hnat

    Crystal Reports extracting data from partial fields entries in a database

    Being in the Travel Industry I am always dealing with fields and tables in a database associated with flight bookings. I have a issue that has stumped me for a long time now and was looking for some guidance. In one table (BOOKING) there is a field that contains the flight routing in linear...
  5. Gary Hnat

    Crystal SQL Code linking to partial database field entries

    Being in the Travel Industry I am always dealing with fields and tables in a database associated with flight bookings. I have a issue that has stumped me for a long time now and was looking for some guidance. In one table (BOOKING) there is a field that contains the flight routing in linear...
  6. Gary Hnat

    How to add multiple delimiters to an MS Access field

    This solution works like a charm and thus eliminates all of the trailing dashes from my new Routing field. Can't thank you enough! Most appreciated! Gary
  7. Gary Hnat

    How to add multiple delimiters to an MS Access field

    Being in the travel business I have a field in a database that contains the trip itinerary showing the city codes all run together ... like JFKMIALAXSEA! I need to still show one field but now need to separate each individual city code, which is 3 characters and enter a dash between them ...

Part and Inventory Search

Back
Top