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 gkittelson 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. JanTeb

    cannot import or export a .dat file

    this used to work and then all of a sudden stopped without any changes being made. In code I find all .dat files and show them in a import screen when I click the file I want an error comes up "You cannot open this file" with only an ok button option. When I try to write a .dat file I get an...
  2. JanTeb

    Outer join doesn't work for transaction table

    Sorry I was trying different things. I did have the null check in there but it didn't always work. Worked for veh 3 scenario but not veh 2.
  3. JanTeb

    Outer join doesn't work for transaction table

    I am fairly new to crystal 9.0 and I am trying to create a report that has 2 tables (SQL 7.0). A master table of vehicles and a transaction table of costs that are connected by an outer join. As soon as I make a date restriction on the transaction table the outer join doesn’t work any more...
  4. JanTeb

    select for records with no matches in date range

    Thanks for all the help. Problem solved.
  5. JanTeb

    select for records with no matches in date range

    Example data is DATA_ENTITIES_COH DATA_STATISTICTRANSACTIONS_COH 1 fueled 10 litres 03/01/01 1 fueled 50 litres 03/02/08 2 fueled 35 litres 03/02/04 2 fueled 40 litres 03/06/20 3...
  6. JanTeb

    select for records with no matches in date range

    What I am trying to do is have 2 tables linked by an outer join and I want to find all vehilces from my first table that have no fuel records (my second table) with in the last 6 months. I can get what has been fueled and I can get what has never been fueled but as soon as I try to put the six...

Part and Inventory Search

Back
Top